thanks gary, ron beat you to it with the same answer, but thanks anyway

"Gary''s Student" wrote:

The easiest way is to put your column headers in the first row and then
select cell A2 and pull-down:

Windows Freeze Panes
--
Gary's Student


"swede" wrote:

in excel i have made a sheet using drop down list boxes for different things
to enter in cells also colomns with the 'now' time function, how do i re-name
colomns i.e A,B,C, etc (if I can) so I can see what colomn is what as the
sheet goes down. I am quite a novice at this and have done everything from ms
help