Microsoft Office Tutorials and References
In Depth Information
Using a Data Table to Analyze Worksheet Data
To Enter the Data Table Title and Column Titles
Selecting Cells
If you double-click the
top of the heavy black
border surrounding an
active cell, Excel will
make the fi rst nonblank
cell in the column active.
If you double-click the
left side of the heavy
black border surrounding
the active cell, Excel will
make the fi rst nonblank
cell in the row the active
cell. This procedure works
in the same fashion for
the right border and the
bottom border of the
active cell.
The fi rst step in constructing the data table shown in Figure 4–20 is to enter the
data table section title and column titles in the range B7:E8 and adjust the heights of
rows 7 and 8.
1 Click the Home tab on the Ribbon. Select cell B7. Enter Interest Rate Schedule as the
data table section title.
2 Select cell B1. Click the Format Painter button on the Ribbon. Select cell B7 to copy the
format of cell B1.
3 Enter the column titles in the range B8:E8 as shown in Figure 4–21. Select the range B8:E8
and then click the Align Text Right button on the Ribbon to right–align the column titles.
4 Position the mouse pointer on the bottom boundary of row heading 7. Drag down until
the ScreenTip indicates Height: 23.25 (31 pixels). Position the mouse pointer on the bottom
boundary of row heading 8. Drag down until the ScreenTip indicates Height: 18.00 (24 pixels).
Click cell B10 to deselect the range B8:E8 (Figure 4–21).
Format
Painter
button
data table section
title formatted
same as cell B1
row heights
increased to
23.25 and 18.00
column titles
right-aligned
in row 8
bottom
boundary of
row heading 7
Expanding Tables
The data table you see in
Figure 4–22 on the next
page is relatively small.
You can continue the
series of percents to the
bottom of the worksheet
and insert additional
formulas in columns to
create as large a data
table as you want.
Figure 4–21
 
 
Search JabSto ::




Custom Search