Here are 3 solutions if you don't want to do use a macro:
1. Sort the three least important columns with the Data Sort command, then
sort the next 3 least import columns, and finally sort the most import.
2. Click in the least important column and click the Ascending or
Descending sort button, move to the next most important column and sort, do
this for all 7 columns working from the least important to the most important.
3. (sort of kidding) Use Excel 2007 for the PC - it allows 64 levels of
sorting
4. If you are using 2004 you can record a macro to do #1 or #2 above. In
2008 you need to write Apple Script, and I don't have any idea about that.
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.