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?
Last edited by Hagar Delest on Fri Jun 27, 2014 11:17 pm, edited 1 time in total.
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.
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.2, 4.1.3 and LibreOffice 126.96.36.199 on Windows 7 Pro & 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.
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 1607 14393.693 LibreOffice 5.2.5
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.