Microsoft Office Tutorials and References
In Depth Information
Adding text to an AutoShape
About the Drawing Layer
Every worksheet and chart sheet has what’s known as a drawing layer. This invisible
surface can hold AutoShapes, graphic images, embedded charts, inserted objects, and
Objects placed on the drawing layer can be moved, resized, copied, and deleted — with
no effect on any other elements in the worksheet. Objects on the drawing layer have
properties that relate to how they are moved and sized when underlying cells are
moved and sized. When you right-click on a graphic object and choose Format Object
from the shortcut menu, you get a tabbed dialog box (see the accompanying figure).
Click the Properties tab to adjust how the object moves or resizes with its underlying
cells. Your choices are as follows:
Move and size with cells: If this option is selected, the object appears to be
attached to the cells beneath it. For example, if you insert rows above the
object, the object moves down. If you increase the column width, the object
Move but don’t size with cells: If this option is checked, the object moves if
rows or columns are inserted, but it never changes its size if you change row
heights or column widths.
Don’t move or size with cells: This option makes the object completely
independent of the underlying cells.
The preceding options control how an object is moved or sized with respect to the
underlying cells. Excel also lets you “attach” an object to a cell. In the Edit panel of
the Options dialog box, place a checkmark next to the check box labeled Cut, Copy,
and Sort Objects with Cells. After you do so, graphic objects on the drawing layer are
attached to the underlying cells.
Because a chart sheet doesn’t have cells, objects placed on a chart sheet don’t have
these options. Chart sheets, however, also have a drawing layer, and objects placed on
the drawing layer float above the other chart elements. Objects on a chart sheet’s
drawing layer have a property that relates to how the object is sized if the chart size
is changed. By default, objects within a chart are sized with the chart. You can change
this so that the object size is not adjusted when the chart is resized.
You can make some basic formatting changes using the buttons on the Formatting
or Drawing toolbars. For example, you can change the color by using the Fill Color
button. Other modifications require that you use the Format AutoShape dialog box.
After selecting one or more objects, you can display this dialog box by using any of
the following techniques: