Formulas -> Defined Names->Define Name
Name a Range
So far so
good. The goal is to select a RANGE of cells and then name it. The
example on this page shows how to create a Defined Name with
the Formula Ribbon.
This: Name a Range
spreadsheet is still open to the Original Data. Cells E1:E70 are selected
Go to Formulas->Defined Names.
Click on Define Name.
You See? You will be prompted to enter a
Name. By default, Microsoft Excel chose the label from Cell E1.
What Else Do You See? The New Name Refers
to: ='Original Data'!$E$1:$E$70
All good formulas begin with equals: =
'Original Data' is the name of the sheet.
The Range of Cells, $E$1:$E$70 is defined with
Absolute Cell References.
Click OK. Keep going...