Thanks.
Since we are at it, is there possible to generate a sequence? For
example I have a excel file and I want to insert a column to the left
and fill that column with a sequence, so that each row is numbered
form 1 though the highest row number? Thanks again.

On Feb 5, 10:52 am, "David McRitchie"
wrote:
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 oglegroups.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.- Hide quoted text -

- Show quoted text -