Microsoft Office Tutorials and References
In Depth Information
The Properties tab of the Format Text Box dialog offers three
choices. “Move and size with cells”, “Move but don’t size with cells”,
and, “Don’t move or size with cells.” As you create your dashboard,
you’ll adjust these options frequently.
Set Up the Rows and Columns
When you compare figures 8-2 and 8-3 you’ll see two major
differences. Figure 8-2 has more figures, of course. But more
important, it uses its rows and columns to control the figures. This
corner from figure 8-2 illustrates the approach.
Here, I plan for cell B3 to contain the title of the
chart, cell B4 to control its height, and cell B5 to
contain the unit of measure for the Y-axis.
To set up this area, first set the widths of
columns B, D, and F to about 17 pixels. To do
so, first select column B by clicking on its
column header. Hold down the Ctrl key and then select columns D
and F. Then set the width of these columns to 17. Similarly, set the
widths of columns C, E, and G to 1. Also set the height of rows 4
and 8 to 65 pixels. You’ll adjust both heights and widths later, but
these will put you in the ball park.
Position the Textbox in its Cells
Anchor the top-left corner of the textbox in the top-left corner of cell
B3. To do so, click and drag the textbox approximately into position.
As you do so, hold down the Alt key. This will cause the textbox to
jump to the top-left corner of each cell it comes near.
Similarly, to position the bottom-right corner, click and drag that
corner while you hold down the Alt key. Then set the property of
this textbox to “Move and size with cells.”