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

English
#1

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.

Freeze row function does not work
#4

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.

#5

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

#6

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” :slight_smile:

#7

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

#11

I’m running Libre 7.1.5.2. I can only freeze the first row. I want to freeze the first two rows and have them print on each page. Regardless how many rows I select, it only freezes the first row. What am I doing wrong?

#12

You are not reading the answer, to which you are commenting. The answers clearly tells:

You should not select rows that you need frozen; you need to put the cursor below the last frozen row.

#13

To print repeating row headers on each page, define a Rows to repeat area.

1 Like
#2

Click in row 3 - select Window | Freeze

If this answer helped you, please accept it by clicking the check mark :heavy_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.

#3

The problem is that there is no “freeze” in Windows anymore

#8

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.

#9

LibreOffice 6.2.8.2.

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,

André,

Geneva, Confederatio Helvetica

#10

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

Impressum (Legal Info) | DatenschutzerklĂ€rung (Privacy Policy)   Content on this site is licensed under a Creative Commons Attribution Share Alike 3.0 license.