Keeping column titles visiable

  • Thread starter Thread starter Sonars_UK
  • Start date Start date
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
 
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
 
Put your cursor just below and just to the right of what you want to FREEZE.
Then,
window>freezepanes
 
Back
Top