[Solved] Freezing panes

Discuss the spreadsheet application
Post Reply
ianbrown
Posts: 1
Joined: Fri Sep 18, 2009 2:23 pm

[Solved] Freezing panes

Post by ianbrown »

In Microsoft excel spreadsheet package there is a facility to "freeze panes", to hold all data above a selected line to always be in view as you scroll through the data below, useful when viewing charts, tables etc.

I have tried using the search and help facility but cannot find a solution, it may be the terminology?

How do you freeze panes in OO Calc?

Cheers

Ian
Last edited by Hagar Delest on Fri Jun 27, 2014 11:17 pm, edited 1 time in total.
Reason: tagged [Solved].
OpenOffice 3.1 on Windows XP Professional
FJCC
Moderator
Posts: 9248
Joined: Sat Nov 08, 2008 8:08 pm
Location: Colorado, USA

Re: Freezing panes

Post by FJCC »

In the Window menu there are options to both Split and Freeze. Select a row or column and choose Split to keep that row or column always visible. Choose a single cell and Freeze if you want to have both horizontal and vertical splits that intersect at the chosen cell.
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.
rpbentert
Posts: 2
Joined: Tue Jun 24, 2014 4:04 pm

Re: Freezing panes

Post by rpbentert »

How can the first two (2) columns and the first two (2) rows be frozen?
rpbentert
OpenOffice 4.1.0 on Windows 8.1
User avatar
RoryOF
Moderator
Posts: 34586
Joined: Sat Jan 31, 2009 9:30 pm
Location: Ireland

Re: Freezing panes

Post by RoryOF »

Put cursor in C3 and select /Window /Freeze (i.e., cursor to the first free - unfrozen- position)
Apache OpenOffice 4.1.15 on Xubuntu 22.04.4 LTS
rpbentert
Posts: 2
Joined: Tue Jun 24, 2014 4:04 pm

Re: Freezing panes

Post by rpbentert »

Thanks. Questions are so simple after you know the answer.
rpbentert
OpenOffice 4.1.0 on Windows 8.1
User avatar
RusselB
Moderator
Posts: 6646
Joined: Fri Jan 03, 2014 7:31 am
Location: Sarnia, ON

Re: Freezing panes

Post by RusselB »

Nobody knows everything, that's why these forums exist, so that the people that do know can share their knowledge with those that don't.
OpenOffice 4.1.7, LibreOffice 7.0.1.2 on Windows 7 Pro, Ultimate & Windows 10 Home (2004)
If you believe your problem has been resolved, please go to your first post in this topic, click the Edit button and add [Solved] to the beginning of the Subject line.
User avatar
pleides
Posts: 4
Joined: Fri Oct 03, 2014 5:22 pm

Re: [Solved] Freezing panes

Post by pleides »

It's not working for me on 4.0.1

I've highlighted the top row as a whole, and again individually.
Windows: Split (& I've tried the Freeze). Nothing stays as I scroll.

What is missing?
OpenOffice 4.0.1
thomasjk
Volunteer
Posts: 4451
Joined: Tue Dec 25, 2007 4:52 pm
Location: North Carolina

Re: [Solved] Freezing panes

Post by thomasjk »

pleides wrote:It's not working for me on 4.0.1

I've highlighted the top row as a whole, and again individually.
Windows: Split (& I've tried the Freeze). Nothing stays as I scroll.

What is missing?
Highlighting the entire row will not produce the desired result. If you want to keep Row 1 visible click in Row 2 and select Window-->Freeze. If you want to Split the window choose Window-->Split. Its an either or choice.
Tom K.
Windows 10 Home version 1803 17134.165
LibreOffice 5.4.7.2
User avatar
pleides
Posts: 4
Joined: Fri Oct 03, 2014 5:22 pm

Re: [Solved] Freezing panes

Post by pleides »

I resolved this by highlighting the row below it as well as the desired row. For some reason, it negates the bottom row selected and does not work with highlighting the single row I wanted to Freeze to the top.

very happy to get it to function. Thank you
OpenOffice 4.0.1
thomasjk
Volunteer
Posts: 4451
Joined: Tue Dec 25, 2007 4:52 pm
Location: North Carolina

Re: [Solved] Freezing panes

Post by thomasjk »

As explained in earlier posts you position the cursor at least one row below or one column to the right of the row/column you wish to split or freeze.
Tom K.
Windows 10 Home version 1803 17134.165
LibreOffice 5.4.7.2
anima
Posts: 1
Joined: Tue Jan 02, 2018 6:53 pm

Re: Freezing panes

Post by anima »

is it possible to freeze rows on the top and at the bottom, or even only from the bottom?
openoffice 4.1.1 on windows 10
User avatar
RusselB
Moderator
Posts: 6646
Joined: Fri Jan 03, 2014 7:31 am
Location: Sarnia, ON

Re: [Solved] Freezing panes

Post by RusselB »

Not with Apache OpenOffice at this time.
OpenOffice 4.1.7, LibreOffice 7.0.1.2 on Windows 7 Pro, Ultimate & Windows 10 Home (2004)
If you believe your problem has been resolved, please go to your first post in this topic, click the Edit button and add [Solved] to the beginning of the Subject line.
Post Reply