3 reasons to use named cells and ranges in Excel forumlas
I use named cells, ranges and constants in my Excel formulas and workbooks for 3 reasons:
- They are easier to explain (to others and to myself 6 months after I create a formula.)
- They are easier to adapt (to other locations in the workbook – absolute cell references not required!)
- They are easier to update (especially named constants in formulas when e.g. rates change.)
These are the steps to follow in this Excel training video:
- Select the cells that you want to name and also the labels in the left column and top row.
- Choose, Insert, Name, Create. Make sure that Left column and top row are selected.
- To verify that your names have been created, click the Name box drop down list of names. Select a name and Excel takes you directly to that cell or range.
- To substitute Name cells and ranges in existing formulas: Choose Insert, Name, Apply, OK
- When you are writing a new formulas and you want to use a name, use the F3 “Paste Name” shortcut combination to select the name you want in the formula and click OK.
- A “Named Constant” does not refer to a cell. Select Insert, Name, Define and then Name the Constant and in the “Refers to” part of the dialog box type in e.g. =0.0825 if you want your Named Constant to refer to a Sales Tax rate of 8.25%
October 18th, 2009 at 6:20 AM
[...] 3 Reasons to use Named Cells and Ranges in Formulas Share and Enjoy: [...]
December 30th, 2009 at 3:19 AM
[...] Tip # 2 – Create a Named Constant. You can watch my lesson on Named Cells, Ranges & Constants. [...]
December 30th, 2009 at 11:22 AM
[...] 3 reasons to use “Named Cell References” in your Formulas [...]
December 30th, 2009 at 11:24 AM
[...] 3 Reasons to use Named Cell references in Formulas [...]
December 30th, 2009 at 2:19 PM
[...] Name cells, ranges and constants and use them in your formulas Share and Enjoy: [...]
May 21st, 2010 at 12:46 PM
[...] Tip # 2 – Create a Named Constant. You can watch my lesson on Named Cells, Ranges & Constants. [...]
December 16th, 2010 at 10:21 AM
[...] 3 reasons to use “Named Cell References” in your Formulas [...]