Microsoft Office Tutorials and References
In Depth Information
To Drill an Entry through Worksheets
To Modify the Portland Sheet
As with the Louisville and Kansas City sheets, the sheet name, tab color, worksheet
subtitle, data, and background colors must be changed on the Portland sheet. The following
steps modify the Portland sheet.
Table 6–7 Portland Units On Hand
Cell
Units on Hand
B5
253
B6
215
B7
352
B8
387
B9
339
B10
282
B11
400
1 Double-click the Sheet3 tab. Type Portland and then press the ENTER key. Right-click the
Portland tab, point to Tab Color on the shortcut menu, and then click Purple (column 10,
row 1 in the Standard Colors area) on the Color palette.
2 Double-click cell A2, drag through the word, Region, and then type Portland to change
the worksheet subtitle.
3 Select the range A1:A2, click the Fill Color button arrow on the Ribbon, and then click
Purple (column 10, row 1 in the Standard Colors area) on the Fill Color palette.
4 Enter the data listed in Table 6–7 in the range B5:B11 (Figure 6–42).
5 Select cell A14 and then click the Save button on the Quick Access Toolbar.
worksheet
subtitle changed
Portland sheet
complete
Portland units
on hand data
sheet renamed
Portland and tab
color changed
Figure 6–42
 
Search JabSto ::




Custom Search