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

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.

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 …

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.

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.

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 …

Rename an Excel table to make it easier to find and refer to in formulas and references.

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

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.