We can assign descriptive names to cell ranges. Named ranges are a special type of address in which we give a name to one cell or a range. A named range is more meaningful than standard range notation because the descriptive name can tell you about the cell contents and it's easier to remember. Since the name is easier to remember, there is less chance for error when entering the cell or range address. Named ranges work like absolute references.
Some rules about naming cell ranges:
Spaces and symbols - except for underscores and periods - are not allowed.
Names must begin with a letter.
Names are limited to 255 characters. However it is good practice to keep the names short, simple, and meaningful.
To select all of the data in the worksheet,
Click any cell that contains data, Press: Control key + A
All of the data is selected.
To move to the Formulas tab, on the Ribbon,
Click the Formulas tab
There are several ways to create named ranges. Today you will create the names from the selected data.
To create the named ranges, in the Defined Names group,
The Create Names from Selection dialog box opens:
Excel has correctly determined that the top row of data contains the column headers. These headers will be used as the names in the named ranges.
To create named ranges,
No obvious changes take place, but the named ranges have been created in the background. These names can be seen in the Name Manager for Windows or the Define Names dialog box for Mac.
To view the newly created named ranges, in the Defined Names group,