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?
 

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


Top