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 …

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.

To name an array constant, click Formula, then Define Name. Enter a name and the constant, then you can use the constant as an array formula.

Use a 3-D reference in Excel to reference several worksheets, such as when you consolidate budget data from different departments in your organization.

Select the range of cells that contains formulas in which you want to replace cell references with defined names. Select a single, empty cell to change the references to names in all formulas …

A reference that refers to the same cell or range on multiple sheets is called a 3-D reference. Use a 3-D reference to consolidate data in different worksheets.

You can create multiple page fields and assign your own item names for each source range. This lets you create partial or full consolidations; for example, one page field that consolidates …

When you work with an Online Analytical Processing OLAP PivotTable in Excel, you can create named sets, a flexible feature that you can use to: Group common sets of items that you can …