Microsoft Office Tutorials and References
In Depth Information
THE PROTECTION TAB
Excel provides no direct way to precisely specify an object’s position (its top and
Contrary to what you might expect, if you rotate an AutoShape that contains
text, the text will not be rotated along with the object.
You can also change the object’s size directly by dragging one of the handles of
the AutoShape. You can change the rotation directly by clicking the small green
circle and then dragging. Note, however, that not all AutoShapes can be rotated.
If multiple objects of different sizes are selected, the Height and Width fields will
be blank. You can then enter values, which will be applied to all the selected
objects — a quick way to force all the objects to be the same size.
THE PROTECTION TAB
The Protection tab determines whether the object is “locked.” Locking has no effect,
however, unless the worksheet is protected. You can protect the worksheet with the
Protect Sheet command.
THE PROPERTIES TAB
The Properties tab of the Format AutoShape dialog box determines how an object is
moved and sized with respect to the underlying cells or chart. See the sidebar
“About the Drawing Layer,” earlier in this chapter.
THE FONT, ALIGNMENT, AND MARGINS TABS
These three tabs appear only if the shape contains text.
The Font tab should be familiar because its options are the same as those for
The controls in the Alignment tab enable you to specify the vertical and
horizontal alignment of the text and choose the orientation. Unlike text contained in
cells, you cannot specify an angle for the orientation (you’re limited to four
orientation options). If you choose the Automatic size option, the shape’s size adjusts to
fit the text that it contains.
The controls in the margins tab allow you to adjust the amount of space along
the sides of the text.
THE WEB TAB
If you plan to save your worksheet as a Web page, you can specify some alternative
text for the object in this tab. The alternative text appears when the user hovers the
mouse pointer over the image in a Web browser. This option is available in Excel
2000 and later.