Help on autofilter sort ascending and descending!

  • Thread starter Thread starter crapit
  • Start date Start date
C

crapit

After I select sort ascending from autofilter, is there anyway to sort back
to the original?
 
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
 
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

removing autofilter sort options 4
Excel 2003 macro for turning on AtoZ autofiltering on a protected 5
limit autofilter drop down menu entries 1
VB macro ascending & decending Alpha sorting on protected sheet 4
How to Sort within AutoFilter with Protection on (and AutoFilter . 1
Sort ascending, make changes, restore previous order 1
Sorting data on button click 1
Sorting results not what I want 1

Back
Top