Ask Your Question
0

Frozen row still sorts?

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

d_rohr 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 4.3.3.2

Thank you in advance.

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted
1

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 5.2.0.4, 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

Comments

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
Login/Signup to Answer

Question Tools

1 follower

Stats

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

Seen: 488 times

Last updated: Sep 11 '16