Microsoft Office Tutorials and References
In Depth Information
To Drill an Entry through Worksheets
2
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
(Figure 6–39).
What is the benefi 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 effi cient way to enter data that is common among worksheets.
same average
unit costs
appear on all
four sheets
Sheet1
Sheet4
Sheet2
Sheet3
Figure 6–39
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
workbook.
With the skeleton of the NextDVR Profi 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
Cell
Units on Hand
B5
335
B6
220
B7
323
 
 
Search JabSto ::




Custom Search