Forum Discussion
Cant push objects off a sheet
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".
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)
I faced very same problem, i tried all the solutions mentioned above, but no avail. Then I noticed that I was able to hide all but two columns. I realized this was because there I had inserted a note in the last column and those two columns were required to show the notes. I edited the notes, moved it to left. Voila, I was able to hide all columns after my content
- mvumesh, What a great find! 👏 I had the same issue with a note and I bet I would have taken hours to find this if it wasn't for this comment. Great detective work 😀
