Forum Discussion
freeze panes, freezes more than I select
jhaynie You don't have to select rows. Just select the cell directly below and to the right of where you want to freeze the rows/columns. In your case, select C1 and then "Freeze panes".
Edit: Reading this post again after a long time and realise that to freeze the first two rows requires you to select A3, then Freeze Panes. Selecting C1 and Freeze Panes will freeze the first two columns. Likewise, C3 and Freeze Panes will freeze the first two rows and columns.
@Riny_van_Eekelen Thank you so much. I never comment on here but I registered so that I could thank you for such an easy solution to such an annoying problem that I have struggled with and tolerated for years. Once again I on a whim decided to ask Google World for an answer and there you were with an solution.
Curious, did you discover this one on your own?
HDD-Portland_Realtor You're welcome. Glad I could help resolve a problem. Can't really remember when I "discovered this". I've been using Excel since it first came out. So, I guess it came "naturally". Never really thought about it, actually.
- Many Thanks too. Great solution to an annoying problem.
