Keeping column titles visiable

[Sonars_UK]

Hi

Some of my columns are getting very long and I am finding it frustrating to
scroll up to the top of the worksheet to make sure that I am inputting into
the correct column.

Is there a away to keep the column title visiable when scrolling down to the
lower realms of a worksheet?

Thanks for any advice.

Regards,

Sonars UK

 

[David McRitchie]

Hi Sonars,
For display you would freeze panes
Select cell B2 then Window (menu), Freeze panes
To unfreeze select all cells, Window, unfreeze panes

You select one cell, or row or column, past what you want
to freeze.

For printing
File, Page setup, Sheet, Rows to repeat at top: $1:$1

More information and other options on the above
http://www.mvps.org/dmcritchie/excel/freeze.htm

 

[Don Guillett]

Put your cursor just below and just to the right of what you want to FREEZE.
Then,
window>freezepanes