"How To Excel" Mini-Tutorials
by TheExcelAddict.com
  
 

Use 'Easy-To-Remember' Names Instead Of Cell References In Formulas


 
Substitute cell references with defined range names in formulasYou can define a cell or range of cells with an 'easy-to-remember' name and then use that name instead of the cell reference in your formulas. Range names are much easier to remember when creating formulas and also makes it easier for users to understand what the formulas do.
 
To create a defined name, select the cell or range of cells, then type a name in the 'Name Box' (i.e. that small white space to the left of the formula bar) and press Enter.
 
A good example would be assigning the name 'tax_rate' to a single cell containing a tax rate that will be used throughout your worksheet. Once you have defined the name, you can use the name instead of the cell reference i.e. =ROUND(C4*tax_rate,2) in your formulas.
 
To insert a range name into your formula, simply position the cursor in the formula, press F5, and double-click the range name you want to insert,

 


 

Get more time-saving tips just like this one delivered to you by email every week in my FREE newsletter "Spreadsheet Tips From An Excel Addict". Subscribe at the www.TheExcelAddict.com/  
You'll be amazed how much time you'll save just by learning a few of these tips.

If you came to this page from my Excel Tutorials page, click here to close this window,
otherwise click here and you'll find lots more time-saving Excel tutorials like this one.