You can quickly create a named range by using a selection of cells in the worksheet. Note: Named ranges that are created from selecting cells have a workbook-level scope.

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.

To select more than one name in a contiguous group, click and drag the names, or press SHIFT and click the mouse button for each name in the group. To select more than one name in a …

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 …

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.

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.

Examples of using COUNTIF in Excel To use these examples in Excel, copy the data in the table below, and paste it in cell A1 of a new worksheet.

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

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.