Title Row that moves with the page

[Plenty11]

Hi,

I have a a row at the top of the page, with about 10 different columns. I enter data every day, so the column gets longer and longer. But then I can not see the title to each column and have to scroll back to the top , check the title and then scroll all the way to the bottom of the page to enter the data.
Is there a way I can get the title to stay in view on the page? regardless to where on the column I am.
If so how do I do it please.

[#2]

@Plenty11 

Click just under the heading and then choose Freeze Panes

Hope that helps

Wyn

MVP

Australia (UTC + 8)

If this answer was the best response please click the button

I also happily accept likes

[#3]

@Plenty11 

Another option is to turn your data into a Table by higlighting it all and pressing Ctrl T

Then you can always see what column your in, and your table automatically gets longer as you type underneath it