sort the minor columns first
D-E-F
then the major columns
A-B-C

More information on sorting:
http://www.mvps.org/dmcritchie/excel/sorting.htm

If you have Excel 2003 then you will have to avoid
the Ctrl+A problem introduced with that version
http://www.mvps.org/dmcritchie/excel...x2k.htm#foobar
---
HTH,
David McRitchie, Microsoft MVP - Excel
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

wrote in message ups.com...
How can I sort the columns in my excel file when it exceeds more than
3? Suppose I have a excel file that has 100 columns and several
thousand rows. How can I sort the file based on 10 columns? Thanks.