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????

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

Mike

"Matt" wrote:

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????

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

"Matt" wrote:

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????

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

"mikebres" wrote:

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

Mike

"Matt" wrote:

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????