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 …

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 …

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 select the Changing cells on your worksheet before adding a Scenario, the Scenario Manager will automatically insert the cells for you, otherwise you can type them by hand, or …

Once you have finalized the LAMBDA function, move it to the Name Manager for final definition. By doing so, you give the LAMBDA function a meaningful name, provide a description, 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.

You can use the Scenario Manager to create both scenarios on the same worksheet, and then switch between them. For each scenario, you specify the cells that change and the values to …

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

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.