ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Question (https://www.excelbanter.com/excel-discussion-misc-queries/85317-question.html)

metaltecks

Question
 
I forgot how to make a column headings permanent, so when you scroll down
they stay at the top. Someone please help.

Thank you

MartinW

Question
 
Hi metaltecks,

Select the entire row below the one you wish to freeze
then go to Windowfreeze frames.

HTH
Martin



Roger Govier

Question
 
Hi

To fix just the first row, place cursor in A2 then WindowsFreeze Panes.
If you want to freeze first column as well, then place cursor in B2
before freezing.

--
Regards

Roger Govier


"metaltecks" wrote in message
...
I forgot how to make a column headings permanent, so when you scroll
down
they stay at the top. Someone please help.

Thank you





All times are GMT +1. The time now is 12:21 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com