I just ran into a problem in Excel where I have a bunch of rows in a 4,000+ row worksheet that are hidden. I normally just click on the upper left corner of the sheet (select all) and then right mouse click on any of the rows and select UnHide. When I do this, it doesn't unhide them. If I do them individually, I can unhide them, but not as a group. It acts the same way if I just drag across two 'unhidden' rows, right click, unhide. That doesn't work either. Any suggestions

It is possible the rows aren't hidden but have had the height set to some
low number, but not zero.

Select in the upper left corner, then set a single row height.

--
Regards,
Tom Ogilvy

sclark wrote in message
...
I just ran into a problem in Excel where I have a bunch of rows in a
4,000+ row worksheet that are hidden. I normally just click on the upper
left corner of the sheet (select all) and then right mouse click on any of
the rows and select UnHide. When I do this, it doesn't unhide them. If I
do them individually, I can unhide them, but not as a group. It acts the
same way if I just drag across two 'unhidden' rows, right click, unhide.
That doesn't work either. Any suggestions?

Tim, good suggestion. I had already tried that. It is really bizarre. I have subsequently found that if I hightlight all rows (by selecting upper left corner), then put my cursor on the row divider for rows that are hidden, then double click it, it unhides them all. But right clicking and selecting unhide no longer works. It has ALWAYS worked that way for me before. Have no idea why it doesn't now.