What is a named range? Cells are generally named for a column
and row that intersect, like A1 or C3. A range of cells is
indicated by the colon between the beginning and ending cell of
the range, like A1:C3, which would include all nine cells in
between. A named range substitutes a user-specified name, like
“Scores,” for score numbers typed in cells A1 through C3.
Creating a named range Select one or more cells, and then click
in the Name Box. It’s located left of the formula bar at the top
of the worksheet, below the Ribbon. If you’re not sure you’re in
the right place, hover and the Name Box tip will pop up. 1. Data
Validation Using a named range to create a dropdown list in a
cell makes data entry easier and cleaner. Without a named range,
the list of acceptable choices must be in the same worksheet as
the target cell. Using a named range allows you to put that list
anywhere in your workbook. Making a tab called “lists,” which
holds all the named ranges used in selection lists, is helpful.
- From the Data