[Solved] Freezing panes

Discuss the spreadsheet application

[Solved] Freezing panes

Postby ianbrown » Fri Sep 18, 2009 2:27 pm

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
ianbrown
 
Posts: 1
Joined: Fri Sep 18, 2009 2:23 pm

Re: Freezing panes

Postby FJCC » Fri Sep 18, 2009 2:55 pm

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.
AOO 3.4 or 4.1 on MS Windows XP ( before 2013-08-03) or Windows 7
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: 4528
Joined: Sat Nov 08, 2008 8:08 pm
Location: Colorado, USA

Re: Freezing panes

Postby rpbentert » Tue Jun 24, 2014 4:10 pm

How can the first two (2) columns and the first two (2) rows be frozen?
rpbentert
OpenOffice 4.1.0 on Windows 8.1
rpbentert
 
Posts: 2
Joined: Tue Jun 24, 2014 4:04 pm

Re: Freezing panes

Postby RoryOF » Tue Jun 24, 2014 4:49 pm

Put cursor in C3 and select /Window /Freeze (i.e., cursor to the first free - unfrozen- position)
Apache OpenOffice 4.1.1 on Xubuntu 15.04 (mostly 64 bit version) and Win2K/XP
User avatar
RoryOF
Moderator
 
Posts: 17219
Joined: Sat Jan 31, 2009 9:30 pm
Location: Ireland

Re: Freezing panes

Postby rpbentert » Tue Jun 24, 2014 5:18 pm

Thanks. Questions are so simple after you know the answer.
rpbentert
OpenOffice 4.1.0 on Windows 8.1
rpbentert
 
Posts: 2
Joined: Tue Jun 24, 2014 4:04 pm

Re: Freezing panes

Postby RusselB » Tue Jun 24, 2014 10:09 pm

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.1 running on Windows 7 Ultimate
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.
RusselB
Volunteer
 
Posts: 1954
Joined: Fri Jan 03, 2014 7:31 am
Location: Sarnia, ON

Re: [Solved] Freezing panes

Postby pleides » Fri Oct 03, 2014 5:27 pm

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
User avatar
pleides
 
Posts: 2
Joined: Fri Oct 03, 2014 5:22 pm

Re: [Solved] Freezing panes

Postby thomasjk » Fri Oct 03, 2014 6:09 pm

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 7 Home Premium
LibreOffice 4.2.5.2
thomasjk
Moderator
 
Posts: 3970
Joined: Tue Dec 25, 2007 4:52 pm
Location: North Carolina

Re: [Solved] Freezing panes

Postby pleides » Fri Oct 03, 2014 6:47 pm

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
User avatar
pleides
 
Posts: 2
Joined: Fri Oct 03, 2014 5:22 pm

Re: [Solved] Freezing panes

Postby thomasjk » Fri Oct 03, 2014 9:24 pm

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 7 Home Premium
LibreOffice 4.2.5.2
thomasjk
Moderator
 
Posts: 3970
Joined: Tue Dec 25, 2007 4:52 pm
Location: North Carolina


Return to Calc

Who is online

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