Prevent objects from moving and sizing with cells

Microsoft Office Excel 2003

Show All Show All

Prevent objects from moving and sizing with cells

  1. Select the object, multiple selection, or group you want to change.

    On an embedded chart, select the chart area by clicking the blank area between the border of the chart and the plot area.

  2. On the Format menu, click the command for the type of object you selected, for example Object or Selected Chart Area, and then click the Properties tab.
  3. Under Object Positioning, select an option to Move but don't size with cells or Don't move or size with cells.