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.

You can quickly create a named range using the currently selected range in your Excel worksheet.

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

To find named ranges of cells, click Home, Find & Select, and Go To, then double-click the named range. You can also go to one or more unnamed ranges.

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.

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 …

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.

If you are seeing the Name Conflict dialog box in Excel, that's because you are trying to copy one or more worksheets to a workbook that has similar named ranges.

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

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 …