Here's how you can create a named range in your spreadsheet:
-
On the Formulas tab, in the Defined Names group, click Define Name.
-
In the New Name dialog box, in the Name box, type the name you want to use for your reference.
Note: Names can be up to 255 characters in length.
-
To specify the scope of the named range, in the Scope drop-down list box, select Workbook or the name of a worksheet in the workbook.
A named range set to a Workbook scope will be available for use throughout the workbook, whereas a range set to a particular sheet's scope can be used within the sheet only.
-
Optionally, in the Comment box, enter a descriptive comment up to 255 characters.
-
In the Refers to box, do one of the following:
-
Click Collapse Dialog (which temporarily shrinks the dialog box), select the cells on the worksheet, and then click Expand Dialog .
-
To enter a constant, type = (equal sign) and then type the constant value.
-
To enter a formula, type = and then type the formula.
-
-
Click OK.
Need more help?
You can always ask an expert in the Excel Tech Community or get support in Communities.