Hi James,
See http://www.mvps.org/dmcritchie/excel/freeze.htm

Select cell B2 then use Window (menu), Freeze

For printing: file, Page setup, sheets
rows to repeat at top $1:$1
Columns to repeat at left $A:$A

There is more information on the above page, including
variation for the Excel 2007.
--
HTH,
David McRitchie, Microsoft MVP -- Excel
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm

"James Silverton" wrote in message
...
Hello, All!

Perhaps I have not woken up properly yet but I have a sheet that is
updated daily and there are several sets of columns derived from the input
values. I sometimes forget which columns are which and have to go to the
top of the page to find the headings. Is there a simple way to do this?
Should I perhaps best write a macro and assign it to a button? Ideally,I
would like to see the values and the headings at the same time?

Thanks in advance.

James Silverton
Potomac, Maryland

E-mail, with obvious alterations:
not.jim.silverton.at.verizon.not