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.

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.

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.

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.

A name is a meaningful shorthand that makes it easier to understand the purpose of a cell reference, constant, formula, or table, each of which may be difficult to understand at first …

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

See examples of how to use worksheet functions to count numbers or dates that fall within a range in Excel.