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

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 …

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 Name Manager dialog box is a central place to manage named ranges in your Excel spreadsheet.

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.

By using names, you can make your formulas much easier to understand and maintain. You can define a name for a cell range, function, constant, or table. Once you adopt the practice of …

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

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 …

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

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