Keeping column titles visiable

S

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
 
D

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
 
D

Don Guillett

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