Ask Your Question

How do I freeze the first two rows on a spreadsheet?

asked 2018-01-20 12:37:35 +0200

tony1 gravatar image

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.

edit retag flag offensive close merge delete

4 Answers

Sort by » oldest newest most voted

answered 2018-01-20 13:29:57 +0200

tony1 gravatar image

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.

edit flag offensive delete link more


Great!. This solves the issue for me. Thanks (y)

anishk gravatar imageanishk ( 2019-01-04 08:21:28 +0200 )edit

Thanks. I'm coming over from Google Sheets, it's the little things that are different. I'm going to have to redirect the "intuition" :)

Chappy gravatar imageChappy ( 2020-04-05 01:21:07 +0200 )edit

(At of 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.

gh0stn0te gravatar imagegh0stn0te ( 2021-02-16 19:44:59 +0200 )edit

answered 2019-11-16 17:26:41 +0200


An Example: Freezing 4 rows (above) :

  1. Select an entire row by click on the sheet's row number 5. (do not select à row by click and slide !)
  2. Then right click on the fifth row number (in the Left column wich/whose is not part of the spreadsheet)
  3. A " menu/list " appears, click on " Freeze Rows and Columns ", Done !

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,


Geneva, Confederatio Helvetica

edit flag offensive delete link more


PLEASE NOTE ---- You need to select the row BELOW the one you want to freeze :)

hammo gravatar imagehammo ( 2020-02-23 11:30:14 +0200 )edit

answered 2019-03-08 11:38:10 +0200

jayvee gravatar image

updated 2019-03-08 11:40:48 +0200

In LibreOffice 5.0, there is a menu button that looks like image description 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.

edit flag offensive delete link more

answered 2018-01-20 12:50:23 +0200

robleyd gravatar image

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.

edit flag offensive delete link more


The problem is that there is no "freeze" in Windows anymore

tony1 gravatar imagetony1 ( 2018-01-20 13:04:51 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2018-01-20 12:37:35 +0200

Seen: 75,630 times

Last updated: Nov 16 '19