After I select sort ascending from autofilter, is there anyway to sort back to the original?
C crapit Dec 12, 2005 #1 After I select sort ascending from autofilter, is there anyway to sort back to the original?
C CLR Dec 12, 2005 #2 If you know the original sorting parameters, then just do Data > Sort, and set them up...............if you don't, then just quit the file without saving and reopen and things will be as they were before you filtered......... Vaya con Dios, Chuck, CABGx3
If you know the original sorting parameters, then just do Data > Sort, and set them up...............if you don't, then just quit the file without saving and reopen and things will be as they were before you filtered......... Vaya con Dios, Chuck, CABGx3
D Dave Peterson Dec 12, 2005 #3 This may not help this time, but you could add another column with just sequence numbers in that column. 1, 2, 3,.... Then sort by whatever you want. Then when you want to return to the original sort order, you can sort by this helper column.
This may not help this time, but you could add another column with just sequence numbers in that column. 1, 2, 3,.... Then sort by whatever you want. Then when you want to return to the original sort order, you can sort by this helper column.
