How To Apply Range Names To Formulas In Excel

Range Names

Named ranges can be great when you are writing formulas. Suppose if you assign the name WidgetPrice to cell A5, you can then use that name, WidgetPrice, in your formulas instead of A5. This will make your formula (and its purpose) easier to understand when you are working with them on a later date.

This approach is great if you have not yet created any formulas. Suppose you already have a bunch of formulas in your worksheet, and they already reference cell A5 instead of WidgetPrice? You could, of course, select each formula and edit them to refer to WidgetPrice instead of A5, but that could certainly be a long process with a wide margin for errors.

The solution is to allow Excel to do the editing for you.

Follow the steps below to learn how to define the Named Range you would like used in your worksheet:

    1. Select the cells that contain formulas.
    2. Display the Formulas tab of your Ribbon.
    3. Click the down-arrow at the right of the Define Name tool (in the Defined Names group) and then select Apply Names. Excel will display the Apply Names dialog box.

  1. Click OK.

That’s all there is to it! Excel will examine your formulas, and any reference to cell A5 is replaced with the name of A5– WidgetPrice.

About the Author

Carol Bratt

Carol holds A+, MCP, and MOS computer certifications and is the resident DCT Office expert. She trains the staffs of small law firms in the use of Microsoft Office applications and has authored many books covering Microsoft Office as well as written articles for Infopackets, TechnoLawyer, and Digital Harbor. For more Microsoft Office tips visit Carol's Corner Office or follow Carol on FaceBook and Twitter.