In Excel, the Name Box refers to an input box directly to the left of the formula bar . The Name Box normally displays the address of the “active cell” on the worksheet. You can also use the name box to quickly create a named range.
Another use for the Name Box is to navigate quickly to any range in a worksheet. If you type Z100 into the Name Box, the active cell will move to that address. If you type A1:A10 into the Name Box, that range will be selected.
Finally, if you have one or more named ranges in a workbook, the Name Box behaves like a drop down menu. You can select and navigate quickly to any name.
The Name Manager is a dialog box in Excel that allows you to create, edit, and delete defined names. These names can be named ranges , named formulas, and named constants. Using named ranges can make formulas easier to read, understand. and maintain Names also provide simple navigation via the Name Box .
To open the Name Manager, navigate to Formulas > Name Manager. Or, you can use the keyboard shortcut Control + F3 .
Names ranges
A named range is one or more cells that have been given a name. Using named ranges can make formulas easier to read and understand. They also provide simple navigation via the Name Box .
The screen below shows three of the four names seen above in the Name Manager in use in a formula based on the FILTER function .
To quickly create a named range, select the range, then type a name into the name box and hit return. For more information, see: Named Ranges in Excel
