• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User


  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Hiding Rows error


New Member
Everytime I try to hide a bunch of rows on this one spreadsheet I keep getting an error saying "Cannot shift objects off sheet." I can't figure out why. Can anyone help me with this? I have never seen this error before when just simply trying to hide multiple rows.

Thank you,



Excel Ninja
Staff member

try the following

- check your rows for merged cells, especially cells merged vertically with rows outside the range your trying to hide, unmerge if you find any

- check for locked cells in that range, unlock any

- use the select tool from the Drawing tool bar and check and remove drawing objects, often these can be invisible, so use the select tool and try and draw a rectangle covering the entire range and see what you can find, these objects often come in with data copied from web pages