By default, hiding an Excel column or row also hides any graphic objects that are anchored to a cell in that column or row. This includes embedded objects, such as charts and pictures, and drawing objects, such as text boxes and AutoShapes. However, you can make sure that these types of objects always remain visible by changing their positioning properties.

To change a graphic’s Object Positioning property:

1. Click on the object to select it.
2. Choose Format | Object Type from the menu bar.
3. Click the Properties tab in the resulting dialog box.
4. Select the Don’t Move Or Size With Cells option button to keep the object in view, as shown in Figure A.
5. When you’ve finished, click OK.

Adapt for Excel 2007
To change an object’s properties in Excel 2007, right-click on the object and choose Size And Properties from the resulting shortcut menu. Click on the Properties tab and then select the Don’t Move Or Size With Cells option button. Click Close.

Filed under: Microsoft Office Tutor