What is a named range?
- One cell, a range, constant value, or a formula with a given name
- User-friendly names for your cells
- Make formulas easier to read and understand
- Range reference can be changed globally in one place
Selecting data for the named range
- Highlight the range, go to the toolbar, select Data, select Named ranges
- Replace default, "NamedRange1", with a meaningful name
- Remember, Named ranges do not like spaces
Creating a named range with the toolbar
- Select Data, Named ranges, Add a range, name it
- Select the data for your range
Editing your named ranges
- Go to Sheets, Data, Named range to see all Named ranges in your workbook
- To change the cell range, select it by clicking the grid to the right
- Less prone to error if you have a visual of your range
Other Common Named Ranges
