KIM Chanthan
Member
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.
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.