Hide & Unhide Rows

[Willman]

I got a problem with rows that are hidden. I can hide rows/cells/columns but it's not possible to unhide them, once they are hidden I can't get them back. What can disable the unhide-function? Are the hidden rows protected some way? Need alot of help here...

[VBA Noob]

Hi,

Select all the cells.
e.g The grey button above 1 (row 1) and left of A (Column A)

Then goto > Format > Columns > Unhide then goto > Format > Rows > Unhide


VBA Noob

[Willman]

I've tried to unhide the hidden rows as you explained but the hidden rows doesn't become visible... What can disable the unhide function while the hide function works just fine? I do not get any error message when I try to unhide the rows...

[starguy]

I've tried to unhide the hidden rows as you explained but the hidden rows doesn't become visible... What can disable the unhide function while the hide function works just fine? I do not get any error message when I try to unhide the rows...

Ctrl+A (to select the whole sheet) or click on the grey button at the left upper side at the intersection of row and column letters.
then
press Ctrl+Shift+9 (to unhide rows)
then Ctrl+Shift+0 (to unhide columns)

hope this would help
Regards.

[joanief]

try re-sizing the rows and columns - it may be that they are "unhiddend" but too small to see??

[Willman]

The problem is solved, Thx for the help, The rows were unhidden but the height of the rows was zero, when I resized the missing rows they became visible. But it was a little tricky. I needed to drag all the rows by the pointer to make them bigger, I tried to select the whole sheet and set the row height to 16 but the rows that had zero height did not change. But after I draged all the "zero-rows" by the pointer it worked to set the height to 16 for the whole sheet thou... Strange... Thanks for all the help