Use "Freeze Panes".

This old post should help explain:

http://tinyurl.com/2qdzt

--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"SunnyLee" wrote in message
...
I'm working in a large spreadsheet. I want to see the column headings
stay
on top of my spreasheet as I'm scrolling down thru multiple pages.

Thank you very much