Ask Your Question

I'm using calc in version I want to freeze two rows at the top of a sheet but only the top row is frozen despite the guides saying that it should freeze all rows above the selected one. I am selecting row three.

asked 2019-03-16 18:01:03 +0200

Slowroaming gravatar image

I see this question has been answered before but it just doesn't work on my sheet. I have version of libreoffice. I select row 3 then click on View, Freeze Cells, Freeze First Row. It does exactly that, the top row is frozen but not row 2.

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2019-03-16 18:27:11 +0200

ebot gravatar image

Put your cursor in cell A3. Select View>Rows/Columns freeze.

edit flag offensive delete link more


Ah so Freeze Cells is for one row but Freeze Rows and Columns is for multiple rows! That does work, thanks

Slowroaming gravatar imageSlowroaming ( 2019-03-16 18:54:11 +0200 )edit

If my answer did solve your problem, please click the big checkmark inside the circle to the left of this answer. It then indicates to the other participants that the question has been answered correctly.

ebot gravatar imageebot ( 2019-03-16 19:27:43 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2019-03-16 18:01:03 +0200

Seen: 36 times

Last updated: Mar 16