[Solved] Freezing panes
[Solved] Freezing panes
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
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].
Reason: tagged [Solved].
OpenOffice 3.1 on Windows XP Professional
Re: Freezing panes
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.
If your question is answered, please go to your first post, select the Edit button, and add [Solved] to the beginning of the title.
Re: Freezing panes
How can the first two (2) columns and the first two (2) rows be frozen?
rpbentert
OpenOffice 4.1.0 on Windows 8.1
OpenOffice 4.1.0 on Windows 8.1
Re: Freezing panes
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
Re: Freezing panes
Thanks. Questions are so simple after you know the answer.
rpbentert
OpenOffice 4.1.0 on Windows 8.1
OpenOffice 4.1.0 on Windows 8.1
Re: Freezing panes
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.
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.
Re: [Solved] Freezing panes
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?
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
Re: [Solved] Freezing panes
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.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?
Tom K.
Windows 10 Home version 1803 17134.165
LibreOffice 5.4.7.2
Windows 10 Home version 1803 17134.165
LibreOffice 5.4.7.2
Re: [Solved] Freezing panes
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
very happy to get it to function. Thank you
OpenOffice 4.0.1
Re: [Solved] Freezing panes
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
Windows 10 Home version 1803 17134.165
LibreOffice 5.4.7.2
Re: Freezing panes
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
Re: [Solved] Freezing panes
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.
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.