Microsoft Office Tutorials and References
In Depth Information
To Drill an Entry through Worksheets
• Hold down the SHIFT key and then click the Sheet1 tab to deselect Sheet4, Sheet2, and Sheet3.
• One at a time, click the Sheet4 tab, the Sheet2 tab, and the Sheet3 tab to verify that all four sheets are identical
What is the beneﬁ t of drilling data through worksheets?
In the previous set of steps, seven new numbers were entered on one worksheet. As shown in Figure 6–39, by drilling the
entries through the four other worksheets, 28 new numbers now appear, seven on each of the four worksheets. Excel’s
capability of drilling data through worksheets is an efﬁ cient way to enter data that is common among worksheets.
appear on all
To Modify the Louisville Sheet
Drilling an Entry
Besides drilling a number
down through a work-
book, you can drill a
format, a function, or a
formula down through a
With the skeleton of the NextDVR Proﬁ t Potential workbook created, the next step
is to modify the individual sheets. The following steps modify the Louisville sheet (Sheet 4)
by changing the sheet name, tab color, and worksheet subtitle; changing the color of the title
area; and entering the units on hand values in column B.
Table 6–5 Louisville Units On Hand
Units on Hand