Why won't th unhide function work??

[Draino]

Why won't the unhide function work on a sheet that I have created. I
previously hid about 175 rows between my last data entry and my summary.
Now when I try to unhide them, nothing happens.

I have to manually drag all of the hidden cells from a height of 0 to 12.75.

Going to format - row height and trying to set them all to 12.75 does not
work either.

Is there a way to do this other than me dragging rows 350 to 175 to open
them all up??

 

[Mike]

Try selecting the 2 rows on either side of the hidden rows and then unhide.

Mike

 

[Draino]

Tried it and still nothing. Not even selecting the entire sheet will work.

 

[Gary''s Student]

Remember that very very short rows can appear hidden. Make sure the rows in
question are not like that.

 

[Draino]

That's the problem. They were not like that - they were hidden, and now they
are acting like short rows. I can not unhide them nor set the height unless
I click and drag them.

 

[Dave Peterson]

Edit|Goto
type:
A175:A350
format|row|unhide

Why won't the unhide function work on a sheet that I have created. I
previously hid about 175 rows between my last data entry and my summary.
Now when I try to unhide them, nothing happens.

I have to manually drag all of the hidden cells from a height of 0 to 12.75.

Going to format - row height and trying to set them all to 12.75 does not
work either.

Is there a way to do this other than me dragging rows 350 to 175 to open
them all up??

 

[Dave Peterson]

Or change the row height
Format|Row|Height

Edit|Goto
type:
A175:A350
format|row|unhide

 

[Draino]

For Now I have figured to use Go To: Edit --> Go To

In the reference box type in the cells in the hidden rows (i.e A109:A130)
These rows are now selected, but hidden.

Next go to: Format --> Row --> Height
Set height at what you want (i.e. 12.75)

The selected rows height changes from 0 to what you selected and they will
appear on screen again.