Microsoft Office Tutorials and References
In Depth Information
To Drill an Entry through Worksheets
Table 6–5 Louisville Units On Hand
(continued)
Cell
Units on Hand
B8
144
B9
195
B10
364
B11
273
1 Double-click the Sheet4 tab. Type Louisville and then press the ENTER key. Right-click
the Louisville tab, point to Tab Color on the shortcut menu, and then click Light Green
(column 5, row 1 in the Standard Colors area) on the Color palette.
2 Double-click cell A2, drag through the word, Region, and then type Louisville to
change the worksheet subtitle.
3 Select the range A1:A2, click the Fill Color button arrow on the Ribbon, and then click
Light Green (column 5, row 1 in the Standard Colors area) on the Fill Color palette.
4 Enter the data listed in Table 6–5 in the range B5:B11 (Figure 6–40).
5 Select cell A14 and then click the Save button on the Quick Access Toolbar.
worksheet
subtitle changed
Louisville sheet
complete
Louisville units
on hand data
sheet renamed
Louisville and tab
color changed
Figure 6–40
 
Search JabSto ::




Custom Search