Microsoft Office Tutorials and References
In Depth Information
your are dragging the image. This will cause the textbox to jump to
the top-left corner of the current cell as you drag the textbox object.
After you position the text box, your worksheet will look something
like Figure 8-3.
Figure 8-3. The first few elements of the mockup of the dashboard report.
Adjust the Text Box Properties
In the next few steps you’ll sometimes want the text box to expand
and contract as you adjust rows and columns. At other times you’ll
want the text box to ignore these adjustments to your worksheet.
To specify how the textbox responds when you adjust rows and
columns, you use the Format Text Box dialog.
However, Excel provides two versions of
this dialog. One allows you to adjust its
internal properties, the other its external
If you right-click within the textbox, you’ll
see the border shown for the top figure
here. When you choose Format Text Box
from this right-click menu, you can adjust
only the font.
But if you right-click on the edge of the textbox, you’ll see the
border shown for the bottom figure. Then, when you choose Format
Text Box from that right-click menu, you can adjust the textbox