How to Define the Name of a Cell or Range of Data
Working with formulas for simplicity it is desirable to designate a cell or range of data. In this part of the tutorial I will try to explain how to name a cell in Excel 2013 as well as to appoint a range of data. As the designated cell or named range of data used in formulas, see the tutorial Create a formula in Excel.
For example, see the image below. It has a table where there are two important elements of data in cells A2 and B2. In cell C2 is a formula that returns the result of the first two cells. Note the formula in D2 (red font) that is found in cell C2. So multiplying the values in cells A2 and B2. In Excel, we have the ability to name each cell a name that can be used in a formula or function as an argument. In this example (figure below) can appoint cells A2 and B2.
Naming cells in Excel can be performed in many ways.
Naming cells in Excel can be done through a New Name dialog box in several ways.
Note: When naming a cell or range of data, the name is visible in the Name Box field (in case you are selected by the respective cell or range of data)'.
- Naming cells via a shortcut ALT + MMD
- Naming cells via 'Name Box' fields in the formula bar.
- Naming cells via the command 'Define Name'
- Naming cells via the command 'Create From Selection'
- Naming cells via the command 'Name Manager'
1. When you want to name a cell or range of data you can press the key combination on the keyboard shortcut ALT+M+M+B and you will open a pop-up window New Name. So select the cells you want to name, then press the specified key combination on the keyboard. It opens you to a new dialog box where the field 'Name': enter the name of the cell that you will use in formulas or functions as an argument. In the field 'Refers To': automatically have the address selected by the name the cell.
2. When you want to name a cell or range of data you can make it through the 'Name Box' field located on the formula bar. Just select a cell (or range of data) and click the mouse in the 'Name Box' field and then enter the desired name a cell or range that you want to later use in formulas or as an argument in functions.
Named cells must not have more words separated by spaces like no special characters, and the name must begin with a letter (the name means should not start number), if you want to enter a name with more words then use one of the forms: newName; new_name; New_Name, New_name_2 etc.. In the picture below you will see that I am appointed cell A2 called 'price' and cell B2 as 'quantity'. Notice the difference of these two formulas that return the same result.
3. If you want, you can designate a cell or range of data via the command: Define Name.
You can position the toolbar Formulas, and then in the Defined Names group commands click the Define Name command.
It opens you to a dialog box New Name. The name by which you have named cell or range of data it can be seen in the 'Name Box' field on the Formula bar.
4. If you want, you can designate a cell or range of data via the command: Create from Selection.
You select the cell or range of data, You can position the toolbar Formulas, and then in the Defined Names group commands on the command click 'Create From Selection'. It opens you to a dialog box as shown below Create Names from Selection.
Notice the four options is called the range of data. I chose Top Row because I want you to be appointed by the range of data called 'A'.
NOTE: When in this way we name a cell or range of data this name or name invisibly in the Name Box field but only you can see it in the Excel Name Manager dialog box.
5. If you want you can name a cell or range of data via dialog windows and commands Name Manager, which is located on the toolbar Formulas (see picture above). Clicking the command Name Manager dialog box opens and it can already be seen named cells or ranges of data, if any in the entire Workbook. Notice the three buttons (New, Edit, Delete).
I believe that you know what with the three buttons you can do :)
So, no need to select a single cell, first open the dialog box and click on the New button and then integrate all the data as follows. In the Refers to field: note at the end of field button to select the cell or range of data on Worksheet.
Naming the Range of Data in Excel
If you wish to appoint more adjacent cells or a greater range of data then all we work as well as for the appointment of a cell just as it comes to a name for the range of data that can be used again in formulas and functions. In the picture below you will see that I am appointed a data range A1:C2 as data_market.