Microsoft Office Tutorials and References
In Depth Information
To manage the named ranges in a workbook, display the Formulas tab, and then, in the
Defined Names group, click Name Manager to display the Name Manager dialog box.
When you click a named range, Excel displays the cells it encompasses in the Refers To
field. Clicking the Edit button displays the Edit Name dialog box, which is a version of the
New Name dialog box, enabling you to change a named range’s definition; for example,
by adding a column. You can also use the controls in the Name Manager dialog box to
delete a named range (the range, not the data) by clicking it, clicking the Delete button,
and then clicking OK in the confirmation dialog box that opens.
Tip If your workbook contains a lot of named ranges, you can click the Filter button in the
Name Manager dialog box and select a criterion to limit the names displayed in the Name
Manager dialog box.
In this exercise, you’ll create named ranges to streamline references to groups of cells.
SET UP You need the VehicleMiles_start workbook located in your Chapter03 practice
file folder to complete this exercise. Start Excel, open the VehicleMiles_start workbook,
and save it as VehicleMiles . Then follow the steps.
1. Select cells C4:G4 .
You are intentionally leaving cell H4 out of this selection. You will edit the named
range later in this exercise.