How Do I Put in My Own Text into Column Headings

[NewBee@excel2007]

I have an excel spreadsheet with over 200 entries and when I scroll down to
input additional data all I see for column headings is A B C etc. I would
much prefer to have headings like Last Name, First Name, Address, City, Zip,
Phone, Cell and so forth displaying at the top of the columns so that when I
am entering data at the bottom of the files I can see what data goes in what
column.

Certainly I am not the first person to have this question but I don't think
I want to pay Microsoft Tech Support $49 to find the solution that should be
easy to find but is not on their website or in Excel 2007 help

Can someone provide an easy solution that is not too technical... I am new
to excel

thanks

 

[Don Guillett]

Place your cursor at cell a2>window>freeze panes

 

[Kassie]

With your preferred headings in Row 1, and your preferred row titles in Col
A, select B2, click on View, and then on freeze panes. Row 1 and Col A will
then always be visible, even if you work in say AB234

--
HTH

Kassie

Replace xxx with hotmail

 

[Victor Delta]

I have an excel spreadsheet with over 200 entries and when I scroll down to
input additional data all I see for column headings is A B C etc. I would
much prefer to have headings like Last Name, First Name, Address, City,
Zip,
Phone, Cell and so forth displaying at the top of the columns so that when
I
am entering data at the bottom of the files I can see what data goes in
what
column.

Certainly I am not the first person to have this question but I don't
think
I want to pay Microsoft Tech Support $49 to find the solution that should
be
easy to find but is not on their website or in Excel 2007 help

Can someone provide an easy solution that is not too technical... I am new
to excel

thanks

Click on cell A2 and then select Windows, Freeze Panes. Job done!

If you want to keep column A in view too, click first on cell B2. Etcetera!

V