Excel Error Codes

How to Fix 'Cannot Shift Objects Off Sheet' Error in Excel

Maira Mehtab Sep 28, 2026 869 views

Question details

The user needs to resolve an error that prevents hiding or inserting columns to the right of their data.

Product: Microsoft Excel
Device & OS: not provided
Scenario: Attempting to hide columns or insert new columns to the right side of an existing data set.
Observed behavior: Excel displays a 'Cannot shift objects off sheet' error message and blocks the action, usually because hidden objects, comments, or shapes are positioned near the edge of the worksheet limits.

Before you start

Ensure that your worksheet is not protected and unhide any previously hidden columns at the far right of your spreadsheet, as hidden columns containing objects can trigger this boundary error.

Solution 1Recommended

Locate and Delete Hidden Objects Using Go To Special

Use Excel's built-in tool to find invisible shapes, text boxes, or controls that are blocking your columns from shifting.

Often, objects or shapes are accidentally created or pushed to the far right of the spreadsheet. Because Excel has a strict limit of 16,384 columns, shifting columns when an object is near the edge will trigger the error.

Open Go To Special

Press Ctrl + G on your keyboard to open the 'Go To' dialog box, then click the 'Special...' button in the bottom left corner.

Select Objects

In the Go To Special menu, select the radio button for 'Objects' and click 'OK'. Excel will highlight all floating objects, charts, and shapes on the active worksheet.

Delete Unnecessary Objects

Look for any highlighted object markers located far away from your main data set and press the 'Delete' key to remove them.

Tip: If you cannot see the selected objects but the selection handles appear, they might be transparent shapes or 0-pixel objects. Deleting them will still resolve the issue.

Solution 2

Clear All Formatting and Comments in Unused Columns

Clear stray comments or hidden formatting in the far-right columns to reset the worksheet boundaries.

Free Microsoft Office alternative

Edit Spreadsheets Without Errors Using WPS Office

Struggling with Excel's object shifting limitations? Try WPS Office. It provides a highly compatible spreadsheet editor that seamlessly manages Microsoft Excel files, letting you format, hide columns, and manage objects without frustrating boundary errors.

1. Download and Install: Get the free WPS Office suite from the official website and install it on your device.
2. Open Your Workbook: Launch WPS Spreadsheets and open your existing .xlsx file.
3. Edit Seamlessly: Hide columns, insert rows, and manage objects without encountering the 'Cannot shift objects' error.

Fully compatible with Microsoft Excel formats (.xlsx, .xls, .csv).Smoothly manage charts, shapes, and comments without layout boundary errors.Lightweight installation and lightning-fast loading speeds.Familiar user interface requires zero learning curve.

microsoft office alternative - wps office

Frequently Asked Questions

Why does Excel say 'Cannot shift objects off sheet'?

This error occurs because an Excel worksheet has a finite number of columns (16,384) and rows. If an object, shape, or cell comment is positioned near the far right or bottom edge, attempting to hide or insert new columns pushes that object beyond Excel's maximum allowed boundaries.

How can I prevent objects from moving with cells?

Right-click the object or chart, select 'Size and Properties', and under the 'Properties' section, choose 'Move but don't size with cells' or 'Don't move or size with cells'. This prevents the object from being pushed off the sheet when you modify columns.

Does clearing cell contents remove hidden objects?

No. Pressing the Delete key or clearing standard cell contents does not remove shapes, text boxes, or certain comments. You must use the 'Clear All' command from the Home tab or select objects directly using the 'Go To Special' feature to completely remove them.

Microsoft Office Error Codes