View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Victor Delta[_2_] Victor Delta[_2_] is offline
external usenet poster
 
Posts: 199
Default How Do I Put in My Own Text into Column Headings

"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