You can quickly create a named range by using a selection of cells in the worksheet. Note: Named ranges that are created from selecting cells have a workbook-level scope.

You can define a name for a cell range, function, constant, or table. Once you adopt the practice of using names in your workbook, you can easily update, audit, and manage these names.

The Name Manager dialog box is a central place to manage named ranges in your Excel spreadsheet.

So, you've named a range of cells, and ... perhaps you forgot the location. You can find a named range by using the Go To feature—which navigates to any named range throughout the entire …

You can quickly locate and select specific cells or ranges by entering their names or cell references in the Name box, which is located to the left of the formula bar. You can also select …

Learn how to create formulas that use descriptive names to represent cells, ranges of cells, formulas, or constant values.

Structured references make it easier to use formulas with Excel tables by replacing cell references, such as C2:C7, with predefined names for the items in a table.

How to sort and organize your Excel data numerically, alphabetically, by priority or format, by date and time, and more.

Use the Name Manager dialog box to work with all the defined names and table names in a workbook. For example, you may want to find names with errors, confirm the value and …

The top reason why the #NAME? error appears in your formula is because there is a typo in the formula name. To avoid typos in formula names, use the Formula Wizard in Excel.