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.

In Excel for the web, you can use the named ranges you've defined in Excel for Windows or Mac. Select a name from the Name Box to go to the range's location, or use the Named Range in a …

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 …

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.

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.

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

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 …

You can lock only specific cells and ranges before you protect the worksheet and, optionally, enable specific users to edit only in specific ranges of a protected sheet.

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.