Ask Your Question

LibreOffice equivalent to Google Spreadsheets' frozen rows ? [closed]

asked 2015-11-10 16:24:44 +0200

updated 2016-03-14 18:49:49 +0200

Alex Kemp gravatar image

Google Sheets (part of Google Drive) has a convenient feature called frozen rows (and columns) that allows to specify (nowadays unlimited number of) rows that'll be the header of any kind you want that are ignored during sorting, and at least some other features; take my spreadsheet for example. What is LO's equivalent ? As far as I know and see, LO and OOo alike don't have anything like that, instead the rows you wanna use as headers get dragged into sorting results.

LO5 preferably, although it doesn't really matter to me cuz I've never seen such feature.

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2016-03-14 18:50:13.267889

1 Answer

Sort by » oldest newest most voted

answered 2015-11-10 16:41:29 +0200

karolus gravatar image


Click into first cell below|right of the areas to freeze and go to →Window→[x]freeze (What a surprise ! ;-)

edit flag offensive delete link more


Well, that's simple enough, although you have to use another road to get there.

rautamiekka gravatar imagerautamiekka ( 2015-11-11 14:51:14 +0200 )edit

Question Tools

1 follower


Asked: 2015-11-10 16:24:44 +0200

Seen: 140 times

Last updated: Nov 10 '15