Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / New Users / December 2005

Tip: Looking for answers? Try searching our database.

Help on autofilter sort ascending and descending!

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
crapit - 12 Dec 2005 12:17 GMT
After I select sort ascending from autofilter, is there anyway to sort back
to the original?
CLR - 12 Dec 2005 13:03 GMT
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

> After I select sort ascending from autofilter, is there anyway to sort back
> to the original?
Dave Peterson - 12 Dec 2005 14:42 GMT
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.

> After I select sort ascending from autofilter, is there anyway to sort back
> to the original?

Signature

Dave Peterson

 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.