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

Place your cursor at cell a2windowfreeze panes

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"NewBee@excel2007" wrote in
message ...
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

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


"NewBee@excel2007" wrote:

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

"NewBee@excel2007" wrote in
message ...
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