Ask Your Question
1

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

3 Answers

Sort by » oldest newest most voted
2

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

Comments

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

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

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

Comments

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

tony1 gravatar imagetony1 ( 2018-01-20 13:04:51 +0200 )edit
0

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
Login/Signup to Answer

Question Tools

1 follower

Stats

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

Seen: 30,296 times

Last updated: Mar 08