Create and find named range

You can assign names to frequently used cells or ranges of cells, and then insert their names into formulas and functions. This is useful when working with large data sets.

A name can be defined (the name of a named range) or tabular (the name of a smart table).

The scope of a name can be global (used on any sheet in the workbook) or local (used only on the sheet where the name was defined).

Quickly create a named range

1. Select a cell or range of cells.
2. Enter a name in the range field.
3. Press Enter.

Create and configure a named range

1. Select a cell or range of cells.
2. Select Define name from the context menu. The Name manager pane opens.
3. Enter the Name for the range.
4. In the Range field, enter the range address or select the desired cells.
5. In the list below, select the scope of the name, such as All sheets or Sheet1.
6. Click Done or press Enter.

You can also use the tools:

Define name on the Data tab.

Name manager in the sidebar.

Quickly find a named range

1. Start typing the range name in the range field.
2. Select the desired range from the list of names.

You can also click the arrow in the range field and select the desired range from the complete list.

Find, filter, and sort named ranges

1. Click the Name manager button on the sidebar. The Name manager pane will open.
2. In the Find field, start typing the name of the range. The list of names will be filtered as you type.
3. In the list below, select an additional filter, such as Defined names or Table names.
4. If you need to sort the list, click the button and select a sorting method.
5. Select the desired named range from the list of names. Its cells will be highlighted on the sheet.

Delete a named range

1. In the Name manager pane, hover over the named range in the list.
2. Click the Delete button and confirm the action.