How do I freeze the first two rows on a spreadsheet?
In view I only seam to be able to do the first one! I have tried to highlight the firs two but does not work.
First time here? Check out the FAQ!
In view I only seam to be able to do the first one! I have tried to highlight the firs two but does not work.
I found this:- Did not work before! Select the row below, or the column to the right of the row or column that you want to be in the frozen region. All rows above, or all columns to the left of the selection are frozen. ... Choose View - Freeze Cells - Freeze Rows and Columns. To deactivate, choose View - Freeze Cells - Freeze Rows and Columns again.
(At of 6.4.6.2) the menu option for 'freeze rows and columns' does exactly (and only) what it says. It freezes both the row and column. If you are trying to freeze a specific axis (only row or only column - and not the first), then it appears you need to highlight the row or column and use the context menu (right-click) for that specific row or column.
LibreOffice 6.2.8.2.
An Example: Freezing 4 rows (above) :
I've Tried in the main bar the option : Main bar > View > Freeze Cell> Freeze First Row... didn't work. Only the first row was freezed ! You should say " he's stupid ", you right. But why click on ? > Freeze Rows and Columns ? not obvious, (If I need more than one Freezed row ? Why clicking on " Rows AND Columns " ???) You can also : Repeat upon [1.] then : Main bar > View > Freeze Rows and Column, worked as well !
Clear the Freezing : It could happend that there's already a row('s) kind of " Freeze formatting" ! and you should/want delete it. So : 1. Select any Row (in the Row's left Column) by click 2. Then right click on the menu list : " Freeze Rows and Columns > it will clear all the formatting about the Freezing.
Sorry for language, I'm not native English speaker,
André,
Geneva, Confederatio Helvetica
In LibreOffice 5.0, there is a menu button that looks like for this purpose. The label for this button is "Freeze Panes".
So, one needs to select a particular column or a row and click on this icon, and all the columns to the left of this column or all the rows above this row will be frozen.
The menu option for this is under Windows > Freeze
If you select a cell in the middle and click on 'Freeze Panes' button, all the rows above this cell and all the columns to the left of this cell will get frozen.
Click in row 3 - select Window | Freeze
If this answer helped you, please accept it by clicking the check mark ✔ to the left and, karma permitting, upvote it. If this resolves your problem, close the question, that will help other people with the same question.
Asked: 2018-01-20 12:37:35 +0200
Seen: 74,509 times
Last updated: Nov 16 '19
How do I export a chart in an image format from LibreOffice Calc? [closed]
Are there plans for a "papercut" project for libreoffice [closed]
Is it normal for Calc goal seek to take very long? [closed]
Please refine "Search" in Calc - implement functions in Gnumeric [closed]
LibreOffice Calc will not link to external data via internet [closed]
Is there a LibreOffice .odt, .ods viewer for Android? [closed]
Why is Calc so much slower at opening/saving files than MS-Office? (win7 x64) [closed]