y2k5

the rows in my Excel file were suddenly hided together.
And the "unhide" function is not working anymore.
Right now I have to unhide them manually. It's really annoying!

Could any excel expert help to solve this problem?
I will really appreciate that!

Thanking in advance!

DOTNET

unhide the rows means expand the rows?

y2k5

Does the EXPAND means to make the row wider?

What I need is to redisplay the rows that are hidding.

dlhonglai

do this:

say, you hided row 3 which you do not see now. select both row 2 and 4 at the same time, and go to Format->Row->Unhide. you should be able to see row 3 now. same procedure with any hided row

good luck

go go dancer

Just select rows besides your hidden rows and right click and select unhide.

example:
rows 2 3 4 are hidden-----select 1 5-----right click-----select unhide

y2k5

But my problem is that I did exactly what you guys said But Nothing happened.
The rows are still stuck together. The method works for the column but not for the rows.
That's why I posted this thread yesterday.
I was wondering if my excel file is corrupted...

Is there any way other than the ones you mentioned above?

Any experts..please help!

go go dancer

It should work for both rows and columns. It works with mine.

If you accidentally set those rows's height to 0, then you might not be able to "unhide them".So you could also try to reset the rows' height by right clicking after select those rows arround your hidden ones.