Microsoft Office Tutorials and References
In Depth Information
Naming groups of data
SET UP You need the VehicleMiles workbook located in the Chapter03 practice file
folder to complete this exercise. Open the workbook, and then follow the steps.
Select cells C4:G4 , intentionally leaving cell H4 out of this selection. You will edit the
named range later in this exercise.
In the Name box at the left end of the formula bar, enter V101LastWeek , and then
press Enter to create a named range named V101LastWeek .
On the Formulas tab, in the Defined Names group, click Name Manager to open the
Name Manager dialog box.
Click the V101LastWeek name. The cell range to which the V101LastWeek name
refers appears in the Refers to box at the bottom of the Name Manager dialog box.
Edit the cell range in the Refers to box to =MilesLastWeek!$C$4:$H$4 (change
the G to an H ), and then click the check mark button to the left of the box to finalize
Click Close to close the Name Manager dialog box.