Cant push objects off a sheet

Occasional Visitor

Im on row 1081 of my excel sheet and when I try to insert a new row a pop up says I "Can't push objects off a sheet".

1 Reply


Before you look at the proposed solution, and since we do not know your Excel version, operating system, storage medium, I recommend performing an update in advance. It is recommended to always provide this information in advance in order to get a quicker and more concrete solution.


This error message occurs when you attempt to insert rows or columns in a worksheet, and the option “Nothing (hide objects)” is selected under the “For objects, show” section in Excel options. This is a known bug in some versions of Excel. 

Although this option is not selected by default, it’s possible to set it accidentally by pressing a particular keyboard shortcut (CTRL+6).

To fix this issue, you can unhide all hidden rows and columns in your worksheet. 

You can do this by selecting all cells in your worksheet by clicking on the box at the top left corner of your worksheet (above row 1 and to the left of column A), then right-clicking on any row or column header and selecting “Unhide” from the context menu.


I hope that helps!


I know I don't know anything (Socrates)