Forum Discussion
Hua-en Chang
Aug 10, 2017Copper Contributor
How to freeze table header row into reference frame?
I received an excel file and it embeds the table name into the reference frame like this picture: ( it only occurs when I scroll down, and touch the table header) can someone tell ...
- Aug 10, 2017The headings showing is a feature of Excel Tables.
To turn a block of data into a Table highlight the block and press Ctrl+T then whenever you click in a Table you will always be able to see the headers even if the top row isn't visible because you have scrolled down. (Your selected cell must be inside the Table to show the headings).
Wyn Hopkins
Aug 10, 2017MVP
The headings showing is a feature of Excel Tables.
To turn a block of data into a Table highlight the block and press Ctrl+T then whenever you click in a Table you will always be able to see the headers even if the top row isn't visible because you have scrolled down. (Your selected cell must be inside the Table to show the headings).
To turn a block of data into a Table highlight the block and press Ctrl+T then whenever you click in a Table you will always be able to see the headers even if the top row isn't visible because you have scrolled down. (Your selected cell must be inside the Table to show the headings).
- Hua-en ChangAug 15, 2017Copper ContributorThanks Wyn!
Finally figure it out