Data - Sort Options

S

SDecker

How can I set up Excel to remember a previous search criteria because I
search by the same columns every time. It is a pain to select those columns
every time. Is there a way for Excel to remember the previous search
criteria I used, and automatically have it listed for the next time I perform
a sort?
 
D

Dave R.

You can record a macro of the sort (tools>macro>record new macro). The macro
recorder will see the range you're sorting, and what you're sorting by, so
you can sort the same range by the same columns by running the macro.
 
Top