To create a named range from selected cells
On the Formula Bar, click the Name Box.
Type the name you want for the range, and then press .
To create a named range from a selection including the name
Select the cells you want to name as a range. Be sure either the first or last cell contains the name for the range.
On the Formulas tab, in the Defined Names group, click Create from Selection.
Select the check box for the cell that contains the name you want. Then click OK.
To display the Name Manager
On the Formulas tab, in the Defined Names group, click Name Manager.
To edit a named range
On the Formulas tab, in the Defined ...