Define name

The name may contain the following elements:

•Letters

•Digits (cannot be used at the beginning of the name)

•Symbols

_ (underscore)

\ (backslash)

. (dot) (cannot be used at the beginning of the name)

The name can be set using the range field (quick way) or using the Name manager.

Define name with range field

You can use a range field to name a cell or a range of cells. The name specified using the range field is global.

To specify a name using a range field, do the following:

1.Select the cell or range of cells to specify a name.

2.Enter a name in the range field.

3.To save the name, press Enter. If you want to delete the data you entered when creating the name, press Esc.

Define a name with Name manager

You can use the Name manager to name a cell, a range of cells, a constant, or a formula.

To specify a name using the Name manager, follow these steps:

1.If you want to name a cell or a range of cells, select the desired cells on the sheet. If you want to name a constant or formula, skip this step.

2.Open the Name manager in one of the following ways:

•On the Data tab, click Define name.

•Right-click the selected cell or cell range to open the context menu and run the Define name command.

•On the Sidebar, click the  Name manager button and in the Name manager, click Define name.

•When working in macOS, select the Data > Define name command from the command menu.

3.In the Name manager, specify the data to create the name:

•In the Name field, specify the name of the cell/range/constant/formula or leave the default name. The default name is [Name_n], where n is the ordinal number of the named item.

•If a name is created for a cell/range, a reference to the cell/range selected in the first step is automatically generated in the Reference field. If necessary, the reference can be edited manually or you can select another cell/range on the sheet with the mouse so that the reference is edited automatically. If a name is created for a constant or formula, enter the desired constant/formula manually in the Reference field.

•In the drop-down list specify where the name will be used: on all sheets of the spreadsheet or on a particular sheet.

4.Click the Done button or press Enter.

The created name appears in the Name manager list.