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

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.

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

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

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.