Microsoft Office Tutorials and References
In Depth Information
To Drill an Entry through Worksheets
To Drill an Entry through Worksheets
The next step is to replace the dummy numbers in the range C5:C11 with the average unit cost for each type
of DVR (Table 6–4). The average unit costs for each category are identical on all four sheets. For example, the aver-
age unit cost for the JVC DVR in cell C5 is $185.61 on all four sheets. To speed data entry, Excel allows you to enter
a number once and drill it through worksheets so it is entered in the same cell on all the selected worksheets. This
technique is referred to as drilling an entry . The following steps drill the seven average unit cost entries in Table 6–4
through all four worksheets in the range C5:C11.
Table 6–4 Average Unit Cost Entries
Company
Average Unit Cost
JVC
185.61
Motorola
165.79
Philips
302.99
Sanyo
296.09
Sony
184.49
Tivo
165.80
Toshiba
297.38
1
With Sheet1 active, hold down the
SHIFT key and then click the Sheet3
tab to select all four tabs at the
bottom of the window.
Select cell C5. Type 185.61 and
then press the DOWN ARROW key.
Enter the six remaining average
unit costs in Table 6–4 in the range
C6:C11 to display the average
unit cost entries as shown in
Figure 6–38.
Excel drills average
unit costs entered on
Sheet1 through to
same cells on Sheet4,
Sheet2, and Sheet3
Sheet4, Sheet2,
Sheet3 selected
Figure 6–38
 
 
Search JabSto ::




Custom Search