Excel 2000 spreasheet starts at line number 2

  • Thread starter Thread starter freeposte
  • Start date Start date
F

freeposte

Hello dear members of the microsoft.public.excel.misc newsgroup. Please I
would need your kind help on this one here. I've got an Excel 2000 documents
inluding many differents spreadsheets. One of those spreasheet present the
following characteristic, the lines begins at number 2. Even if I do insert
a new line the new one is the line number 2.

How could I remediate this please.

Thank-You

Octavio
 
First go to cell A1 by pressing F5, entering A1 and clicking OK. Then do a
Format, Row, Unhide.
 
If either of the above still doesn't work try goto 1:2 right click
mouse, choose row height and enter 10. This will set both rows 1 and 2
at a height of 10 and then you can resize as needed

Hope this helps

Mike
 
Hi,

It means row 1 is hidden.

- press F5 (goto)
- enter A1, press OK
- From Excel's menu: Format, Row, Unhide.

Regards,

Jan Karel Pieterse
Excel TA/MVP
 
Hi there Octavio
it sounds like your first line has been hidden. To get it
back select lines 2,3,and 4 - right mouse-click and
select 'Unhide' from the menu.
Hope this helps
 
Back
Top