I see this question has been answered before but it just doesn’t work on my sheet. I have version 6.2.1.2 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.