floating header

[Matt]

I have to keep a record of numbers and it is so far 76 rows long; more than a
screen shows without scrolling. I keep forgeting which column is which. Is
there a way I can have the titles of my columns remain at top of the screen
as I scroll down the page? I think someone told me it was called a floating
header????

 

[mikebres]

Use Freeze from the Windows menu. Place the cursor just below where you want
the static header to be then select Freeze.

Mike

 

[KePaHa]

If headingsa re in row 1, click on cell A2 and then choose Window, Freeze Panes

 

[Matt]

Thank you. This makes my Excel life a lot easier.