Unhide Row Problem (Excel 2000 SR-1)

Topic

New Reply

I have a workbook that has hidden rows that I can’t unhide using the normal format-column-unhide way. Any ideas?

Reply | Quote

Replies

The rows are not hidden, their height has been set to zero. Select rows 4 through 9 and then select Format/Row/Autofit and they should reappear.

Reply | Quote

Legare,

The row height for rows 5 through 8 wasn’t exactly 0; it showed as 0,75 points on my PC (Excel 97 SR2, WinNT 4.0). In fact, setting row height or column width to 0 is equivalent to hiding a row or column, AFAIK.

Reply | Quote

Thank you

Reply | Quote

Yes, I saw that, I just thought it might muddy the issue.

Reply | Quote

The rows aren’t really hidden, but have a very small row height of 0,75 points. Try the following:
Click the row header of row 4.
Shift+Click the row header of row 9.
Change the row height by selecting Format/Row/Height… of by dragging the bottom edge of the row header of row 9.

Reply | Quote