Here's how you can create a named range in your spreadsheet:
On the Formulas tab, in the Defined Names group, select Define Name.
In the New Name dialog box, in the Name box, type the name you want to use for your reference.
Note
You can use up to 255 characters for the name.
To specify the scope of the named range, in the Scope drop-down list, select Workbook or the name of a worksheet in the workbook.
A named range set to a Workbook scope is 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:
- Select Collapse Dialog (which temporarily shrinks the dialog box), select the cells on the worksheet, and then select 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.
Select OK.
Need more help?
You can always ask an expert in the Excel Tech Community or get support in Communities.