Ask Your Question

undo auto filter sort ascending in calc

asked 2020-02-16 04:44:25 +0100

clos911 gravatar image

I did an auto filter on a column of numbers, the numbers are in no particular order. I then selected sort ascending on the auto filtered column and they were sorted low number to high, very nice. now I want them back to the original order... I cannot find the method to return them back.. any help is appreciated.

edit retag flag offensive close merge delete

2 Answers

Sort by » oldest newest most voted

answered 2020-05-24 12:58:09 +0100

newbie-02 gravatar image

updated 2020-05-26 08:36:08 +0100

if you have saved inbetween the only [edit] 'original' / [/edit] 'normal' may be in your backup,

if not [ctrl-Z] may help you out, if you did other changes after the sort you'll need more than one ctrl-Z and loose the subsequent changes,

undo is quite powerful and mostly correct in calc, standard is 100 steps stored, for some actions it needs multiple ctrl-Z for undo as the steps are divided into substeps, thus sometimes you see no 'action' on the screen but calc does something internally,

you can see if and how many steps are available on the yellow 'undo-arrow-button' in the menu bar,

edit flag offensive delete link more

answered 2020-02-16 08:26:31 +0100

ebot gravatar image

updated 2020-02-16 08:27:21 +0100

Click the "AutoFilter" icon in the toolbar "Standard" or in the Data>AutoFilter menu.

edit flag offensive delete link more


yes thats how I apply and remove my auto filter.. after doing so I did a sort ascending. I now want to remove the sort ascending and return the sheet to normal...

clos911 gravatar imageclos911 ( 2020-02-18 18:52:57 +0100 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2020-02-16 04:44:25 +0100

Seen: 280 times

Last updated: May 26 '20