How to Fix “Fixed Objects Will Move” Warning in Microsoft Excel

Working inside a complex data workbook in Microsoft Excel only to be interrupted by a persistent dialogue box warning “Fixed objects will move” every single time you apply an AutoFilter, sort a table, hide a row, or delete a column is an extraordinarily irritating obstacle. You click OK, perform your action, and within seconds the exact same warning pops up again.

The “Fixed objects will move” alert is an intentional Excel notification. It warns the user that graphical objects (such as form control checkboxes, drawing shapes, chart boundaries, or legacy cell comment boxes) are anchored to cells whose row heights or column widths are being collapsed to zero. If an object is configured with rigid size properties that prevent it from collapsing alongside the filtered rows, Excel alerts you that it is forced to displace the shape. This comprehensive guide explains how to reconfigure object properties, identify hidden off-sheet shapes, and silence the warning permanently.

Method 1: Change Object Properties to “Move and Size with Cells”

The standard root cause of this warning is an object whose placement property is configured as “Move but don’t size with cells” or “Don’t move or size with cells”. Updating the shape formatting allows it to collapse seamlessly when rows are hidden.

1. Open the Excel worksheet where the warning occurs.
2. Right-click the problematic shape, image, chart, or form control. (If you have multiple objects, hold Ctrl and click each one).
3. Select Format Shape… (or Format Control… / Format Picture…).
4. In the Format pane on the right-hand side, click the Size & Properties icon (a square with dimension arrows).
5. Expand the Properties section.
6. Select the radio button labelled Move and size with cells.
7. Close the formatting pane, save your workbook, and test filtering your data rows. The warning will no longer trigger for those objects.

Method 2: Batch Select and Reconfigure All Sheet Objects via Go To Special

In large worksheets containing dozens of small checkboxes, buttons, or icons, manually right-clicking individual objects is tedious. Excel allows you to select every shape simultaneously.

1. On your worksheet, press F5 (or Ctrl + G) to open the Go To dialogue box.
2. Click the Special… button in the lower-left corner.
3. In the Go To Special window, select the Objects radio button.
4. Click OK. Excel will instantly highlight and select every graphical object, shape, button, and floating comment on the active worksheet.
5. With all objects selected, right-click any one of the highlighted objects and select Format Object….
6. In the Properties tab, select Move and size with cells.
7. Click OK to update all objects across the worksheet in a single action.

Method 3: Convert Legacy Cell Comments to Threaded Notes

Legacy Excel cell comments (distinguished by small red triangles in cell corners) are treated by Excel as floating drawing shapes. If a comment box has shifted off-screen or sits over a filter boundary, filtering rows triggers the “Fixed objects will move” alert.

1. Go to the Review tab in the Excel ribbon.
2. In the Notes section, click Show All Notes.
3. Scan your sheet for comment boxes that have become elongated or displaced thousands of rows down the sheet.
4. Right-click the border of any displaced comment box and select Format Comment….
5. In the Properties tab, select Move and size with cells and click OK.
6. Alternatively, if legacy comments are no longer required, convert them to modern threaded comments: click Review > Convert Notes to Comments.

Method 4: Locate and Delete Ghost Shapes via the Selection Pane

Workbooks exported from external reporting engines (such as SAP, Salesforce, or Oracle) frequently contain microscopic or invisible 0-pixel drawing shapes anchored near column headers.

1. Go to the Home tab in the ribbon.
2. In the Editing group on the far right, click Find & Select.
3. Click Selection Pane….
4. The Selection pane will open on the right, listing every named object, shape, and text box present on the worksheet.
5. Inspect the list for mysterious entries named Picture 1, Straight Connector, or AutoShape.
6. Click on each item in the Selection Pane to highlight it on your sheet. If it corresponds to unneeded visual debris, press the Delete key on your keyboard to permanently eliminate it.

Excel “Fixed Objects Will Move” Reference Matrix

Refer to this diagnostic guide to determine the quickest remedy for object warnings:

Workbook Scenario	Underlying Root Cause	Recommended Solution
Warning appears on applying AutoFilter	Form control checkboxes anchored with “Don’t size”	Change shape properties to “Move and size with cells”
Warning strikes when deleting empty columns	Legacy cell comments overlapping column borders	Format Comment > Properties > “Move and size with cells”
Sheet has no visible shapes, but warning fires	Microscopic ghost shapes from ERP/SAP export	Open Home > Find & Select > Selection Pane > Delete shapes
Dozens of form buttons scattered across sheet	Individual property settings mismatch	Press F5 > Special > Objects > batch format properties
Warning occurs on macro running Sort/Filter	VBA code triggering UI alert popups	Add Application.DisplayAlerts = False in macro code

Suppressing Object Alerts in Automated VBA Macros

If you administer automated financial models where visual warnings disrupt unattended background macros, suppress the dialogue programmatically. In your VBA macro module, wrap your sorting and filtering routines with alert suppression: insert Application.DisplayAlerts = False immediately before your filter logic, and restore user alerts by adding Application.DisplayAlerts = True at the conclusion of the procedure.