• 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

    Hui...

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

Excel Cannot hide row

Hi,
Can anyone help to recommend as i have a problem regarding hiding row in excel.
Between row 374 to 439 (I divided into 2 parts from 374 to 406, and from row 407 to 439).
Between these 2 parts, i can only hide 1 part. Ex: If i hide part 1 (row 374 - 406) first, i cannot hide the 2nd part (Row 407-439).
Or if i hide 2nd part first, i will not able to hide the 2nd part. Also, i cannot hide all both part at the same time.
The error message is "Can't push objects off the sheet".
However, if i unhide all row, then i can hide back normally, but i don't want to touch any unrelated row.

Appreciate if you can help.
 

Attachments

  • Book2.xlsm
    286.5 KB · Views: 6
Hi,​
according to this obvious message I can hide part 1 and after part 2 once I deleted all pictures (23) …​
 

Attachments

  • Book2 .xlsb
    160.8 KB · Views: 0
Back
Top