Excel Name Ranges - AdvantEdge Training & Consulting

Excel Name Ranges

Identify cells and data with Excel name ranges.
Excel name ranges make finding and identifying data easier. They can also be used in formulas in place of cell references. This makes formulas easier to understand and build.
To use Excel name ranges in a formula:

    • Select your desired cells
    • Excel Name Box
    • In the Name Box, above the row headings, type a name for the range (you cannot use spaces) then press Enter
    • Go to any other spreadsheet
    • Click the drop-down arrow in the Name Box and choose your named range from the list and note how it places you back into the spreadsheet with that range of cells selected
    • Click in a cell and type a formula such as: =Sum(
    • Excel Defined Names
    • On the Formula tab in the Defined Names group, click the Use in Formula button and select the name of your range from the menu
    • Type a close parentheses ) and press Enter
    • View the formula in the formula bar and note that it does not use cell references but rather your named range

Excel Name Ranges

For more ways to make Excel work for you, take a training course from AdvantEdge Training & Consulting!

If you have at least 5 people we can create a session just for you.  Or, you can contact us for a private session. Contact Us

Questions? Don't see what you need?

We can help!

Business Training Classes
AdvantEdge Training & Consulting, Inc.

Recent Posts

Subscribe to our Newsletter

Copyright AdvantEdge Training & Consulting

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

Scroll to Top