Hidden Rows

[figz]

I am trying to unhide some hidden rows in a worksheet that
was sent to me. Rows 1 and 2 are hidden. I've tried the
simple route of selecting the entire sheet, pulling down
the Format menu, and selecting unhide. I've also tried
Ctrl-G (GoTo) and typing in A1. That doesn't work. The
document is not protected nor are any of the cells (that I
know of).

 

[Bernie Deitrick]

Figz,

Two other possibilities:

1) The window has frozen panes, so use windows / unfreeze panes

2) The row height is jsut very very small. Select all the cells using the
button to the upper left of cell A1, then right click on a row label and
choose "Row height...." and then enter some number, say 10.

One or the other of these should do it.

HTH,
Bernie
MS Excel MVP

 

[Frank Kabel]

Hi
what happens exactly: Do you get an error message?

 

[Gord Dibben]

Perhaps they are not hidden, but height set to zero.

Try the goto A1 with CRTL + G then Format>Row>Height

Gord Dibben Excel MVP