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 formula.

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.

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 using names in …

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 workbook.

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 glance. The following …

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

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.

This article uses a sample worksheet to illustrate Excel built-in functions. Consider the example of referencing a name from column A and returning the age of that person from column C.

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.