Can I sort a list with more than three fields?

[Teres]

Dear all,

I use Excel XP. If I choose from the Menu, Data>Sort ... I can only specify
three fields heading to sort data. How can I sort more than three fields?
For example, I want to sort with the follwong four fields: country, prodcut
catagories, product and vendor!
------------------
Country Product Catagories Product Vendor
UK Plastic Tray Hightech Plastic Engineering Ltd
UK Paper Tray Everlasting Plastic Products Limited
China Plastic Tray Durable Plastic Factory
China Paper Box Paper Craft Ltd
China Paper Box Artist Paper Coporation

-----------------

Please advice and thanks for advanced!

Best regards,
Teres

 

[Anne Troy]

Try this, Teres:

http://www.officearticles.com/excel/sort_by_more_than_three_columns_in_microsoft_excel.htm
*******************
~Anne Troy

www.OfficeArticles.com

 

[Teres]

I check from the HELP menu myself and found the method to sort four columns,
is four columns the maximum fields I can sort?

Regards,
Teres
=================

 

[Teres]

Thanks and got it!

Regards,
Teres

Try this, Teres:

http://www.officearticles.com/excel/sort_by_more_than_three_columns_in_microsoft_excel.htm
*******************
~Anne Troy

www.OfficeArticles.com

 

[Earl Kiosterud]

Teres,

You can sort on as many columns as you want. Every time you do a sort (up
to three columns), then another, the boxes in Data - Sort of the earlier
sort are as if its boxes were under the boxes for the later sort. Just work
your way from the bottom to the top. It can go on forever.

This is also true of using the quick sort buttons (A-Z) on the standard
toolbar. Only there you can sort on only one column at a time. Again, work
your way backwards.