[Solved] How to freeze header row

Discuss the spreadsheet application

[Solved] How to freeze header row

Postby Mate88 » Thu Nov 14, 2019 9:20 pm

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
Mate88
 
Posts: 2
Joined: Thu Nov 14, 2019 9:16 pm

Re: How to freeze header row

Postby FJCC » Thu Nov 14, 2019 9:22 pm

Put the cursor in cell A2 and then select the menu Window -> Freeze.
Windows 10 and Linux Mint, since 2017
If your question is answered, please go to your first post, select the Edit button, and add [Solved] to the beginning of the title.
FJCC
Moderator
 
Posts: 7385
Joined: Sat Nov 08, 2008 8:08 pm
Location: Colorado, USA

Re: How to freeze header row

Postby Mate88 » Fri Nov 15, 2019 3:34 pm

I knew it had to be simple - Thank you!
open office 4 windows 10
Mate88
 
Posts: 2
Joined: Thu Nov 14, 2019 9:16 pm

Re: How to freeze header row

Postby RoryOF » Fri Nov 15, 2019 3:40 pm

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.7 on Xubuntu 18.04.3 (mostly 64 bit version) and very infrequently on Win2K/XP
User avatar
RoryOF
Moderator
 
Posts: 29899
Joined: Sat Jan 31, 2009 9:30 pm
Location: Ireland


Return to Calc

Who is online

Users browsing this forum: Google [Bot] and 44 guests