Instead of splitting the window, you can freeze the panes:

Select the row below your headings
Choose WindowFreeze Panes.

Or, to freeze row and column headings:
Select the cell to the right of your row headings, and
below your column headings, e.g. cell B2
Choose WindowFreeze Panes

morisn wrote:
Hello. I've seen this before but cannot figure out how to do it myself.
I would like to have a way to leave the title bar of an Excel 2002
spreadsheet fixed in the same position as I scroll down the rest of the table
without using the split bar above. I don't know if this requires macros or
not, but have tried the help feature and search in the MS knowledge base
without success.
Anyone can help?
Thanks
Oscar M.


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html