Written by Allen Wyatt (last updated April 24, 2021)
This tip applies to Excel 97, 2000, 2002, and 2003
Named ranges can be a great boon when you are writing formulas. For instance, if you assign the name TaxRate to cell A7, you can then use the name TaxRate in your formulas instead of A7. This makes your formulas (and their purpose) easier to understand when you are later working with them.
This approach is great if you have not yet created any formulas. What if you already have a bunch of formulas in your worksheet, and they already reference cell A7 instead of TaxRate? You could, of course, select each formula and edit them to refer to TaxRate instead of A7, but that could be a long process that is prone to mistakes. (My fat fingers often introduce mistakes that I never intended. :>))
The solution is to allow Excel to do the editing for you. It is easy to do; just follow these steps:
Figure 1. The Apply Names dialog box.
That's it; Excel examines your formulas and any reference to cell A7 is replaced with the name of A7, TaxRate.
ExcelTips is your source for cost-effective Microsoft Excel training. This tip (8262) applies to Microsoft Excel 97, 2000, 2002, and 2003. You can find a version of this tip for the ribbon interface of Excel (Excel 2007 and later) here: Applying Range Names to Formulas.
Create Custom Apps with VBA! Discover how to extend the capabilities of Office 365 applications with VBA programming. Written in clear terms and understandable language, the book includes systematic tutorials and contains both intermediate and advanced content for experienced VB developers. Designed to be comprehensive, the book addresses not just one Office application, but the entire Office suite. Check out Mastering VBA for Microsoft Office 365 today!
When processing data in a worksheet, you may have a need to know what the smallest (lowest) even value in a range is. You ...
Discover MoreNeed to know a count of unique values in a range of cells? There are a couple of ways you can tackle the problem.
Discover MoreExcel is usually more flexible in what you can reference in formulas than is immediately apparent. This tip examines some ...
Discover MoreFREE SERVICE: Get tips like this every week in ExcelTips, a free productivity newsletter. Enter your address and click "Subscribe."
There are currently no comments for this tip. (Be the first to leave your comment—just use the simple form above!)
Got a version of Excel that uses the menu interface (Excel 97, Excel 2000, Excel 2002, or Excel 2003)? This site is for you! If you use a later version of Excel, visit our ExcelTips site focusing on the ribbon interface.
FREE SERVICE: Get tips like this every week in ExcelTips, a free productivity newsletter. Enter your address and click "Subscribe."
Copyright © 2025 Sharon Parq Associates, Inc.
Comments