Excel 2000 spreasheet starts at line number 2

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
 
J

Jim Rech

First go to cell A1 by pressing F5, entering A1 and clicking OK. Then do a
Format, Row, Unhide.
 
F

Freemini

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
 
J

Jan Karel Pieterse

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
 
P

Paul Falla

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
 

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