Sign in with Microsoft
Sign in or create an account.
Select a different account.
You have multiple accounts
Choose the account you want to sign in with.

Here's how you can create a named range in your spreadsheet:

  1. On the Formulas tab, in the Defined Names group, click Define Name.

  2. 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.

  3. 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.

  4. Optionally, in the Comment box, enter a descriptive comment up to 255 characters.

  5. In the Refers to box, do one of the following:

    • Click Collapse Dialog Button image(which temporarily shrinks the dialog box), select the cells on the worksheet, and then click Expand Dialog Button image.

    • To enter a constant, type = (equal sign) and then type the constant value.

    • To enter a formula, type = and then type the formula.

  6. Click OK.

Need more help?

You can always ask an expert in the Excel Tech Community or get support in Communities.

Define and use names in formulas

Need more help?

Want more options?

Explore subscription benefits, browse training courses, learn how to secure your device, and more.

Communities help you ask and answer questions, give feedback, and hear from experts with rich knowledge.

Was this information helpful?

What affected your experience?
By pressing submit, your feedback will be used to improve Microsoft products and services. Your IT admin will be able to collect this data. Privacy Statement.

Thank you for your feedback!