Page 1 of 1

[Solved] How to freeze header row

PostPosted: Thu Nov 14, 2019 9:20 pm
by Mate88
Hi all - how do I 'freeze' the top row (header) so as to keep column headers in view while scrolling down sheets?
Thanks - M8

Re: How to freeze header row

PostPosted: Thu Nov 14, 2019 9:22 pm
by FJCC
Put the cursor in cell A2 and then select the menu Window -> Freeze.

Re: How to freeze header row

PostPosted: Fri Nov 15, 2019 3:34 pm
by Mate88
I knew it had to be simple - Thank you!

Re: How to freeze header row

PostPosted: Fri Nov 15, 2019 3:40 pm
by RoryOF
That also works for columns, or rows and columns. Place cursor in the first unfrozen cell needed and select /Window /Freeze.