Names are meaningful notations that can be assigned for a cell or cell range and used to simplify working with formulas. Creating a formula, you can insert a name as its argument instead of using a reference to a cell range. For example, if you assign the Annual_Income name for a cell range, it will be possible to enter =SUM(Annual_Income) instead of =SUM(B1:B12). In such a form, formulas become clearer. This feature can also be useful in case a lot of formulas are referred to one and the same cell range. If the range address is changed, you can make the correction once using the Name Manager instead of editing all the formulas one by one.
There are two types of names that can be used:
Names are also classified by Scope, i.e. the location where a name is recognized. A name can be scoped to the whole workbook (it will be recognized for any worksheet within this workbook) or to a separate worksheet (it will be recognized for the specified worksheet only). Each name must be unique within a single scope, the same names can be used within different scopes.
To create a new defined name for a selection:
The New Name window will open:
Note: a name cannot start from a number, contain spaces or punctuation marks. Underscores (_) are allowed. Case does not matter.
Change the link to the cell range in the entry field or select a new range on the worksheet with the mouse and click OK.
To quickly create a new name for the selected range of cells, you can also enter the desired name into the name box located to the left of the the formula bar and press Enter. A name created in such a way is scoped to the Workbook.
All the existing names can be accessed via the Name Manager. To open it:
The Name Manager window will open:
For your convenience, you can filter the names selecting the name category you want to be displayed: All, Defined names, Table names, Names Scoped to Sheet or Names Scoped to Workbook. The names that belong to the selected category will be displayed in the list, the other names will be hidden.
To change the sort order for the displayed list you can click on the Named Ranges or Scope titles in this window.
To edit a name, select it in the list and click the Edit button. The Edit Name window will open:
For a defined name, you can change the name and the data range it refers to. For a table name, you can change the name only. When all the necessary changes are made, click OK to apply them. To discard the changes, click Cancel. If the edited name is used in a formula, the formula will be automatically changed accordingly.
To delete a name, select it in the list and click the Delete button.
Note: if you delete the name that is used in a formula, the formula will no longer work (it will return the #NAME? error).
You can also create a new name in the Name Manager window by clicking the New button.
To quickly navigate between cell ranges you can click the arrow in the name box and select the necessary name from the name list – the data range that corresponds to this name will be selected on the worksheet.
Note: the name list displays the defined names and table names scoped to the current worksheet and to the whole workbook.
To add a name as an argument of a formula:
Note: the Paste Name window displays the defined names and table names scoped to the current worksheet and to the whole workbook.
Please note that AVS4YOU programs do not allow you to copy protected material. You may use this software in copying material in which you own the copyright or have obtained permission to copy from the copyright owner.
AVS4YOU is a registered trademark of Online Media Technologies, Ltd., UK. Intel and Core 2 Duo are registered trademarks of Intel Corporation. AMD and Athlon X2 are registered trademarks of Advanced Micro Devices, Inc. Windows 10/8.1/8/7/XP/2003/Vista are registered trademarks of Microsoft Corporation. All other trademarks are the property of their respective owners.