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 Chang
Aug 15, 2017Copper Contributor
Thanks Wyn!
Finally figure it out
Finally figure it out