Microsoft Office Tutorials and References
In Depth Information
The default option is Move And Size With Cells, meaning that if you do anything to change
the size or shape of the underlying cells, the object adjusts accordingly. An underlying cell is
any cell whose right or bottom border is between the upper-left corner and the lower-right
corner of the object. Here are some facts you need to know about these options:
If you insert columns or rows to the left of an object formatted with the Move And
Size With Cells option, the object moves accordingly.
● If you insert columns or rows between the first and last cells underlying an object
formatted with the Move And Size With Cells option, the object stretches to
accommodate the insertion.
If you select the Move But Don’t Size With Cells option and then insert or delete
columns or rows, the object moves but retains its shape and proportion.
● If you select the Don’t Move Or Size With Cells option, the object floats above the
worksheet and isn’t affected by any changes you make to the underlying cells.
The Print Object check box is ordinarily selected. If you clear it, the selected object
isn’t printed when you print the worksheet.
In addition to moving and sizing objects with cells, Excel lets you control what happens
when you cut, copy, or sort cells to which objects are attached. Click the File tab, click
Options, select the Advanced category, and in the Cut, Copy, And Paste group, select or
clear the Cut, Copy, And Sort Inserted Objects With Their Parent Cells check box.
The Size category in the Format Shape task pane offers precise control over the height,
width, angle of rotation, scale, and cropping of the selected object. You can perform these
tasks directly by dragging, but you might find it helpful to display the task pane if you want
to resize objects proportionally using the Lock Aspect Ratio option.