Freezing panes

Discuss the spreadsheet application

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
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.0 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: 3678
Joined: Sat Nov 08, 2008 8:08 pm
Location: Colorado, USA


Return to Calc

Who is online

Users browsing this forum: No registered users and 13 guests