Excel Fixed Objects Will Move Error: How to Fix

The Excel message ‘Fixed objects will move’ usually means a worksheet object—such as a chart, shape, picture, or note—is interfering with an action that changes cells or rows. Find the object first, then either adjust its placement setting or remove it if it is unnecessary; don’t delete every object blindly, because that can erase useful content.

What the warning means

Excel worksheets can contain drawing objects as well as cells. An object has a position relative to the sheet, and many objects also have a setting that controls how they respond when cells around them move or change size. The warning appears when Excel encounters an object that may be affected by an operation it is trying to perform, such as inserting or deleting rows or columns.

Despite the wording, the message does not necessarily mean the object is broken or that your workbook is damaged. It is a warning about the relationship between an object and the cell grid. The object might be visible, partly covered by another object, or hidden in a row or column. A worksheet can also contain objects far from the area you are currently viewing.

Common objects include charts, pictures, shapes, buttons, text boxes, and legacy notes. A threaded comment is different from a legacy note, and not every kind of comment behaves like a drawing object. The exact cause can therefore take some investigation, especially in a workbook created by someone else or copied from an older file.

Why Excel raises it

Objects have placement options that determine how they relate to cells. Depending on the object type, the options include Move and size with cells, Move but don’t size with cells, and Don’t move or size with cells. The last option keeps an object anchored to a fixed position on the worksheet rather than letting it follow cell changes. That can be useful for a floating logo or dashboard decoration, but it can conflict with operations that alter the grid.

For example, suppose a worksheet has a chart beside rows 1 through 20, and the chart is set not to move or resize with cells. If you insert rows near the chart, Excel may be unable to carry out the change in the way it expects while preserving the object’s fixed position. A picture, button, or other shape may be the cause instead; the object does not have to be in the exact cell where you clicked.

Another possibility is that objects are hidden from view. Hiding drawing objects does not necessarily remove them from the workbook, so an operation can encounter an object that you cannot see on the sheet. This is why the warning can seem unrelated to the visible layout.

Find the object before changing anything

Start by saving a separate copy of the workbook. Then make Excel display the worksheet’s objects and inspect the likely area. On Windows in Excel for Microsoft 365, check File > Options > Advanced. Under Display options for this workbook, find For objects, show and select All. The setting applies to the selected workbook. If objects appear after you change it, look for items hidden behind cells, other objects, or rows and columns.

You can also use Excel’s selection tools to locate objects:

Open Home > Find & Select > Selection Pane to see and select many shapes and drawing objects. The pane can also help you identify overlapping objects by hiding and showing them.
Use Home > Find & Select > Go To Special > Objects to select drawing objects on the active worksheet. Pressing F5 opens Go To; choose Special from that dialog to reach the same selection option.
Check the sheet’s edges and areas with hidden rows or columns. An object can be positioned outside the table or dashboard area you normally use.

Take care with Go To Special. Selecting objects is not the same as identifying which one is safe to remove. If you press Delete while multiple objects are selected, you may remove charts, buttons, pictures, or shapes that the worksheet needs. Deselect the group and inspect items individually, or use the Selection Pane to narrow down the source.

Fix the placement setting

If you want to keep an object, change how it responds to cell changes. Select the object, open its formatting options, and look for the Size & Properties section and its Properties choices. For a shape or picture, this is usually available in the Format Shape or Format Picture pane. For a chart, select the chart and open its formatting options; the wording and pane layout can vary by object type.

Choose the placement rule that matches the worksheet’s purpose. Move and size with cells makes the object follow changes to its underlying cells and change size as those cells change. Move but don’t size with cells lets the object follow cell movement while retaining its dimensions. If an object must stay at a fixed screen position, Don’t move or size with cells may be appropriate—but it can be a poor fit for a sheet where rows and columns are frequently inserted or removed.

Test the operation that triggered the warning after changing the setting. If there are several objects, change one at a time so you can see which one matters. Do not assume every picture or chart should use the same rule: a chart intended to stay beside a data table may need to move with it, while a decorative logo may need to retain its size.

Remove an object only if it is unnecessary

If you find a stray object that has no purpose, select that specific item and delete it. A blank-looking shape or button might still be part of a form, report, or dashboard, so inspect it before removal. If a sheet contains dozens of objects, the Selection Pane is generally safer than selecting everything at once because it lets you identify and manage items individually.

For a workbook you did not create, consider asking its owner before deleting controls or changing a dashboard layout. Form controls and buttons may be connected to macros or workbook processes. Deleting one can remove an interface element even if it looks like an ordinary shape. Keep the backup until you have confirmed that the worksheet still works as intended.

Check hidden objects and the affected operation

If no obvious object appears, confirm that For objects, show is set to All for the workbook. The Windows shortcut Ctrl+6 can cycle how objects are displayed in Excel. It changes their display state; it does not delete objects or change their placement properties. If objects seem to disappear after using it, press the shortcut again or return to the Advanced display setting and select All.

Also note exactly what you were doing when the message appeared. Inserting rows, deleting cells, changing a filter, or editing a sheet can expose a problem that was already present. If it happens only on one worksheet, focus your search there. If it happens in multiple workbooks, check whether the same object or display setting is involved before concluding that Excel itself needs repair.

After making a change, try the original action on a small, reversible example if practical. For instance, test inserting one row near the affected area rather than making a large structural edit immediately. If the warning remains, undo the test if possible, continue checking for other objects, and avoid repeatedly making the same change without understanding its effect.

Windows, Mac, and Excel for the web

The steps above describe Excel for Microsoft 365 on Windows. Excel for Mac also provides object formatting and selection tools, but the ribbon arrangement and keyboard shortcuts differ. Use the Mac menus and formatting panes to locate the object’s properties rather than assuming a Windows shortcut or dialog path will be identical. The Windows Ctrl+6 shortcut should not be treated as a Mac instruction.

Excel for the web has a more limited set of worksheet-object editing features than the desktop application. If you cannot access a needed object property or manage a hidden object in the browser, open the workbook in the Excel desktop app and make the change there. Before editing, confirm that the workbook is saved and that you are working on the intended copy.

Frequently Asked Questions

What does ‘Fixed objects will move’ mean in Excel?
It means Excel has encountered one or more worksheet objects whose placement may conflict with the cell or row operation you are trying to perform. The object may be a chart, shape, picture, control, or note; the warning alone does not identify which one.

How do I find hidden objects in an Excel sheet?
In Windows Excel, set File > Options > Advanced > For objects, show to All. Then inspect the sheet with Home > Find & Select > Selection Pane or use Go To Special > Objects to select drawing objects.

Can I press Delete after selecting all objects?
Only if you are certain every selected object is unnecessary. That action can remove charts, buttons, pictures, and other useful items. Save a copy first, and use the Selection Pane to inspect objects individually when you need to preserve some of them.

Does Ctrl+6 fix the error?
Not by itself. In Windows Excel, Ctrl+6 changes how drawing objects are displayed, which may help reveal an object that was hidden. It does not remove an object or change its move-and-size setting, so use it as a visibility check rather than a permanent repair.

Why does the warning appear when I insert a row?
A drawing object on the worksheet may have a placement setting that prevents it from following cell changes in the expected way. Look across the active sheet, including areas outside the visible table, then adjust the relevant object’s properties or remove it only if it is genuinely unneeded.

Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.

More in Errors & fixes

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.