[Solved] How to freeze header row

Discuss the spreadsheet application
Post Reply
Mate88
Posts: 2
Joined: Thu Nov 14, 2019 9:16 pm

[Solved] How to freeze header row

Post 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
Last edited by Hagar Delest on Fri Nov 15, 2019 7:18 pm, edited 2 times in total.
Reason: tagged solved.
open office 4 windows 10
FJCC
Moderator
Posts: 9277
Joined: Sat Nov 08, 2008 8:08 pm
Location: Colorado, USA

Re: How to freeze header row

Post by FJCC »

Put the cursor in cell A2 and then select the menu Window -> Freeze.
OpenOffice 4.1 on Windows 10 and Linux Mint
If your question is answered, please go to your first post, select the Edit button, and add [Solved] to the beginning of the title.
Mate88
Posts: 2
Joined: Thu Nov 14, 2019 9:16 pm

Re: How to freeze header row

Post by Mate88 »

I knew it had to be simple - Thank you!
open office 4 windows 10
User avatar
RoryOF
Moderator
Posts: 34618
Joined: Sat Jan 31, 2009 9:30 pm
Location: Ireland

Re: How to freeze header row

Post by RoryOF »

That also works for columns, or rows and columns. Place cursor in the first unfrozen cell needed and select /Window /Freeze.
Apache OpenOffice 4.1.15 on Xubuntu 22.04.4 LTS
Post Reply