Ask Your Question

Frozen row still sorts? [closed]

asked 2016-09-11 06:28:23 +0200

d_rohr gravatar image

updated 2020-09-12 08:29:50 +0200

Alex Kemp gravatar image

I'm new to LibreOffice and am trying to compile information into the Calc program.

I have the information entered & have frozen the first row to ask as a header. However, the issue I am running into is that, when I attempt to sort the data, the frozen header row sorts itself into the data. I have looked around and found a few topics similar to this but I am not able to get any of them to work.

Any help would be greatly appreciated. I am utilizing LibreOffice

Thank you in advance.

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 2020-09-12 08:30:07.919585

1 Answer

Sort by » oldest newest most voted

answered 2016-09-11 07:35:59 +0200

mark_t gravatar image

updated 2016-09-11 20:49:42 +0200

From the menu "Data", "Sort", select the Options tab, then check the option for "Range contains column labels".

I'm using LO, but I think this would still be similar on earlier versions.

Edit: You can select top row and use menu "Data", "Autofilter" to give drop down menu on the headers for sorting by one column, similar to Excel.

edit flag offensive delete link more


This actually works perfectly. Thanks, mark_t

I was hoping to actually find something comparable to Excel where it generates the drop menus so sorting can be done much faster. However, this will have to do for now...

d_rohr gravatar imaged_rohr ( 2016-09-11 16:19:32 +0200 )edit

Question Tools

1 follower


Asked: 2016-09-11 06:28:23 +0200

Seen: 1,553 times

Last updated: Sep 11 '16