Forum Discussion
Title Row that moves with the page
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.
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 Replies
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
Click just under the heading and then choose Freeze Panes
Hope that helps
Wyn
MVP
Australia (UTC + 😎
If this answer was the best response please click the button
I also happily accept likes
