Microsoft Office Tutorials and References
In Depth Information
To Drill an Entry through Worksheets
To Modify the Kansas City Sheet
Importing Data
Costs, such as those
entered into the
range C5:C11, often are
maintained in another
workbook, a fi le, or a
database. If the costs are
maintained elsewhere,
ways exist to link to a
workbook or import
data from a fi le or data-
base into a workbook.
Linking to a workbook
is discussed later in this
chapter. For information
on importing data, see
the From Other Sources
button on the Data tab
on the Ribbon.
The following steps modify the Kansas City sheet (Sheet 2).
Table 6–6 Kansas City Units On Hand
Cell
Units on Hand
B5
403
B6
281
B7
228
B8
312
B9
357
B10
278
B11
345
1 Double-click the Sheet2 tab. Type Kansas City and then press the ENTER key. Right-click
the Kansas City tab, point to Tab Color on the shortcut menu, and then click Red
(column 2, row 1 in the Standard Colors area) on the Color palette.
2 Double-click cell A2, drag through the word, Region, and then type Kansas City to
change the worksheet subtitle.
3 Select the range A1:A2, click the Fill Color button arrow on the Ribbon, and then click Red
(column 2, row 1 in the Standard Colors area) on the Fill Color palette.
4 Enter the data listed in Table 6–6 in the range B5:B11 (Figure 6–41).
5 Select cell A14 and then click the Save button on the Quick Access Toolbar.
worksheet
subtitle changed
Kansas
City sheet
complete
Kansas City units
on hand data
sheet renamed
Kansas City and
tab color changed
Figure 6–41
 
Search JabSto ::




Custom Search