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 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 Author

Dave Bruns

Hi - I’m Dave Bruns, and I run Exceljet with my wife, Lisa. Our goal is to help you work faster in Excel. We create short videos, and clear examples of formulas, functions, pivot tables, conditional formatting, and charts.   

Excel Name Manager - 37