Sign up ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

In OpenOffice Calc, the only feature I miss from Excel is the ability to create those dropdown dialogs to sort data:

enter image description here

Does OpenOffice Calc have the same feature and I just missed it?

Note: I know the Data>Sort dialog, but I am looking for something that does not require to select the area every time.

share|improve this question

2 Answers 2

up vote 3 down vote accepted

AFAIK openoffice doesn't have a sort option built into the AutoFilter Dropdown box, as Excel has. But sorting doesn't require to manually select the data area (only if there are empty rows/columns in the data area), so just use the sort buttons from the command bar to sort the data.

share|improve this answer
Thanks! The sort buttons from the command bar just sort according to the first column, as far as I know. – Nicolas Raoul Jun 13 '11 at 9:27
hmm - it depends on which cell is selected. If you select, for example, C2, the data should get sorted according to the third column. Even header cells seem to be recognized (this is why i proposed C 2 :-) ) – tohuwawohu Jun 13 '11 at 9:38
Indeed! That's perfect. – Nicolas Raoul Jun 13 '11 at 10:11

If I understand correctly, you want to:

  • Select one or more contiguous columns
  • Go to menu Data::Filter::AutoFilter (or whatever i18n'd menu name you see in your version - position in the menu tree should be the same). Click it.

AutoFilter menu

  • See the new dropdown handle appear on all column headers
  • Click on handle to apply the kind of filter or sort rule that you want.

enter image description here

Valid for OOo 3.3 and LibreOffice 4.2 and 4.4 (where the screenshots come from).

share|improve this answer
Hm, I'm not seeing these options in OpenOffice 4.1.1, just the default ones "All, Top 10, Standard Filter, etc". Was this feature removed again? – sp00n Oct 4 at 12:48

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.