Hide Unhide Rows

[blackstar]

I'm hidding multiple rows in 2 sheets. when i click format/rows/unhide on one
sheet it unhides all of them but on the other sheet it doesn't unhide any of
them.. any ideas why this might be happening? same rows are being hidden on
both sheets.

 

[blackstar]

sorry what i meant was. when i select the entire sheet on 1 can do the unhide
works for all the rows. but when i do the same thing on the other sheet it
doesn't unhide anything...i have to end up doing them one at a time..takes a
while when you have 200 rows...so did i format the sheet maybe somehow that's
preventing me from unhiding them all in one shot?

 

[Jim May]

Each sheet is independent of the other;
you can perhaps "Group" these two sheets
BEFORE clicking, JUST REMEMBER to UNGROUP
Immediately afterwards!!!