Named Fields in Excel
|
613-749-4695 |
Tips and Ideas on Excel |
Tips and Ideas on Macros |
Excel Chapter 8A of 24: Name Fields in ExcelIn Excel you can name cells and sets of cells. Naming cells can be useful to simplify the writing of formulas specially the use of the dollar signs to make references absolute. For example: =A1
and =nfMyField
are the same if you have named cell A1 "nfMyField" You will notice that it becomes very useful with SUMPRODUCT and INDEX/MATCH formulas. Instead of writing a formula like this: Instead of writing a formula like this: In these 2 previous formulas MAKE SURE that both named fields have the same number of cells. Naming a field in Excel To name a cell or a set of cells (range) in Excel you select it or them and you go to the Name Box at the top right of the screen just above the column line and beside the formula bar. The "Name Box" tooltip appears when you put the cursor above it.:
In the Name Box above you see B3 which is the address of the cell that is selected. Click in the name box and write nfMyField and THEN CLICK ENTER. The selected cell or set of cells in now named. Select any other cell, go to the small arrow right of the name box and click on it. You see a list of your named field. Select nfMyField and the cell or the set of cells that you have named gets selected. Always use the prefix " nf" when you name a field you will not regret it when you start programming in VBA. Remember that after naming a field in the Name Box YOU MUST CLICK ON ENTER. Maintaining Named Fields in Excel Sometimes you want to delete a named field or modify the cell or cells that it comprises. Go to "Insert/Name/Define" and you will see the following dialog box.
If you want to delete a named field select it in the list and when it appears in the box over the list click on "delete" . To modify its range go to the box "Refers to" change the addresses and then CLICK ON ADD. Don't forget to CLICK ON ADD. As you can see instead of using the quick method above (in the Name Box) to name fields you can also do it in this dialog window. |
Next Chapter: Signs and Formulas in Excel |
Excel Table of Contents |
Discover Even More in 50 Excel spreadsheets |
|
613-749-4695 |
Tips and Ideas on Excel |
Tips and Ideas on Macros |
Named Fields in Excel