Hello,
There is an example of my project. How can I make the first row stable, so when I scroll down the worksheet, it will not disappear?
Excel VBA Course - From Beginner to Expert
200+ Video Lessons
50+ Hours of Video
200+ Excel Guides
Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)
How to freeze the rows
0
Answers
0
Selected Answer
Jayden
To freeze row 1, go to the View ribbon, Window subsection, click the down arrow on "Freeze Panes..." then click "Freeze Top Row". You'll now see a grey line below row 1 to indicate it's frozen.
More interesting perhaps is the Freeze Panes option there. If your sheet had many rows and many columns, you might want to freeze the top row and the two leftmost columns. To use Freeze Panes, you click in the cell just within the area where the data will scroll (so C3 in this case) then click Freeze Panes option. Now (if you are within the unfrozen data area, if you scroll down, the top row will always be visible and if you scroll right, columns A and B will always show.
If your want to remove a freeze, go back the Freeze Panes... down arrow and click "Unfreeze Panes".
Hope this helps.
Discussion
OK, I got you, thanks a lot!
Jayden Smith (rep: 10) Oct 5, '21 at 3:48 am
Great! Thanks for selecting my Answer, Jayden.
John_Ru (rep: 6142) Oct 5, '21 at 3:49 am