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.
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,
Click the "AutoFilter" icon in the toolbar "Standard" or in the Data>AutoFilter menu.
Asked: 2020-02-16 04:44:25 +0100
Seen: 280 times
Last updated: May 26 '20
Content on this site is licensed under a Creative Commons Attribution Share Alike 3.0 license.
