repeating a data sort

J

Jacques Brun

Try the following
Tools >Macros >Record New Macro

Your are prompted for a macro name and associated key
stroke.

Then perform your sort. The commands will be recorded in
the macro. At the end click on the "Stop Recording button"

By entering the selected key strocke your sort will be
automatically executed.


-----Original Message-----
I have an excel 2003 worksheet
I repeatedly do the same 3 way data sort of the same 5 of 6 columns.
Can I set this sort up as a key stroke rather than
clicking data | sort everytime?
 
Top