Define name of cell range
When working with large data sets, frequently used cells or cell ranges can be named.
Tools
–Range field — located to the left of the formula bar. To expand the field, move the cursor over its right border (the cursor will look like a bidirectional arrow 
), press the left mouse button and move the border to the right.
–Name manager — opens by clicking the 
Name manager button on the sidebar.
Name types
–Preset — names that the user has manually assigned to cells or ranges.
–Tabular — names of tables created automatically in Microsoft Excel (also called smart tables).
Name scopes
–Global — can be used on any worksheet in the table.
–Local — can only be used on the sheet on which they were specified.
Creating a named range
Create a named range via the range field 1.Select a cell or range of cells. 2.In the range field, type a name. 3.Press the Enter key. Create a named range through the Name manager 1.Select a cell or range of cells. 2.Open the Name manager using one of the methods: •On the Data tab, click the Define name button. •Right-click the selection and choose Define name from the context menu. •On the sidebar, click 3.In the dialog box, specify: •Name — enter a name or leave the default name [Name_n]. •Range — the reference to the selected cells will be substituted automatically. If necessary, you can edit it manually or select a new range on the sheet. •Scope — select from the list where the name will be used: on all sheets or on a specific one. 4.Press the Done button or the Enter key. The created name will be displayed in the list in the Name manager panel. |
Finding and selecting a named range
Find and select a range using the Range Field –Quick search: click on the range field, start typing the name and select the desired option from the list with the mouse or the ↓/↑ + Enter keys. –Select from the full list: Click the arrow in the range field and select a name from the drop-down list with the mouse or the ↓/↑ + Enter keys. Find and select a range using the Name Manager 1.Open the Name manager in one of the following ways: •Click •In the range field, click the arrow and select Manage defined names. 2.To search the list of names, use: •Find bar — start typing a name and the list will filter as you type. •Filtering — click the All names field and select the group to display. •Sorting — click on the ↓↑ button and select the method. To see which range of cells corresponds to the name, select it in the list — this range will be highlighted on the sheet. |
Insert a named range into a formula
To insert a named range into a formula or function, you can use any of the find and select methods described above. The selected name is inserted into the formula, and the corresponding cell range is highlighted in the table. |
Delete a named range
1.Open the Name manager (see above). 2.In the list, hover over the name you want to delete. 3.Click |
