Lost Rows ?

G

Guest

Hi

I am using Win2000 & Excel 2000. I have a spreadsheet that starts from row
4. I assumed that rows 1,2 & 3 must have been hidden but when I try to unhide
rows it still remains starting at row 4. I have tried selecting the entire
sheet and selecting "unhide rows" but it remains the same. Any idea how I get
back rows 1, 2 & 3. ?

Any help would be much appreciated.

Thanks

John
 
D

Dave Peterson

Hit F5 (or Edit|Goto) type in A1:A3.
Format|rows|Unhide
then window|Unfreeze panes. Then scroll up.
 
D

Dirk Van de moortel

John Calder said:
Hi

I am using Win2000 & Excel 2000. I have a spreadsheet that starts from row
4. I assumed that rows 1,2 & 3 must have been hidden but when I try to unhide
rows it still remains starting at row 4. I have tried selecting the entire
sheet and selecting "unhide rows" but it remains the same. Any idea how I get
back rows 1, 2 & 3. ?

Any help would be much appreciated.

Thanks

John

Perhaps your rows 1, 2 and 3 have zero height.
Try selecting all the rows and adjust the height by dragging
the border line between two rows in rows margin.

Dirk Vdm
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top