How to Fix Excel Cannot Push Objects Off the Sheet Error
Question details
The user is unable to collapse grouped rows, hide columns, or apply filters due to an error message stating objects cannot be pushed off the sheet.
- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Attempting to hide, insert, or filter worksheet rows or columns when shapes, charts, or comments are present.
- Observed behavior
- Excel blocks the action and displays the error message 'Cannot push objects off the sheet' or 'Cannot shift objects off sheet'.
Before modifying object properties or deleting hidden shapes, save a backup copy of your Excel workbook to ensure you do not lose any critical charts or form controls.
Adjust Object Properties to Move and Size with Cells
This is the most reliable method. It ensures that charts, images, and shapes resize dynamically when rows or columns are hidden, preventing them from being pushed off the grid boundary.
Excel displays this error when an object's properties are set to 'Don't move or size with cells' or 'Move but don't size with cells'. When you hide rows, the object retains its size and gets pushed toward the bottom or right edge of the 1,048,576-row / 16,384-column grid. Changing the property resolves the conflict.
Press 'F5' to open the Go To dialog box, click on the 'Special' button, select 'Objects' from the list, and click 'OK'. This highlights every shape, chart, and comment in your active worksheet.
Right-click on any of the highlighted objects and select 'Size and Properties' or 'Format Object' from the context menu. A formatting pane will appear on the right side of your screen.
In the formatting pane, expand the 'Properties' section. Select the radio button for 'Move and size with cells'. Once applied, try hiding or collapsing your rows again.
Toggle the Display of Objects
Use this quick keyboard shortcut to temporarily hide all objects, allowing you to manipulate your rows and columns immediately.
Locate and Delete Rogue or Invisible Objects
Sometimes invisible artifacts, leftover comments, or tiny 0-pixel shapes are stuck near the edge of the worksheet causing the error.
Avoid Frustrating Spreadsheet Errors with WPS Office
If Excel's object placement errors continue to interrupt your workflow, try WPS Office. As a free, lightweight Microsoft Office alternative, WPS Spreadsheet offers seamless compatibility with your existing files and an intuitive interface that makes managing charts, shapes, and massive datasets effortless.
- 1. Download the software: Visit the official WPS Office website to download the free, lightweight installation package for your operating system.
- 2. Install WPS Office: Run the installer and follow the simple on-screen instructions to set up the software in minutes.
- 3. Open your spreadsheet seamlessly: Launch WPS Spreadsheet and open your existing .xlsx files to edit data, manage objects, and hide rows without frustration.
Frequently Asked Questions
Why does Excel say 'Cannot shift objects off sheet'?
This happens when a chart, shape, or cell comment is placed near the edge of the worksheet (such as row 1,048,576), or when its properties prevent it from resizing. Hiding rows above it would push it completely off the grid boundary, which Excel does not allow.
Does the Ctrl+6 shortcut permanently fix the error?
No. Pressing Ctrl+6 toggles the display of objects on and off. While it allows you to bypass the error temporarily to hide or group rows, you must eventually adjust the object properties to 'Move and size with cells' for a permanent fix.
How do I find hidden objects causing this error?
You can find hidden objects by pressing F5 to open the Go To dialog, clicking 'Special', and selecting 'Objects'. Alternatively, you can open the Selection Pane from the Home tab (Find & Select > Selection Pane) to view and manage a list of all objects on the sheet.
Can cell comments cause the 'cannot push objects' error?
Yes. Excel treats cell comments and notes as objects. If a comment box is positioned far away from its source cell, or near the bottom/right edges of the sheet, hiding rows can trigger the boundary error. You may need to edit or delete the distant comment.
