Sort multiple columns by alphabetical order

H

hello

Hello

I have many columns (100 or so) in a spreadsheet, and I want to sort them
all by alphabetical order. Can this be done easily? The Data, Sort menu seems
to only sort one column at a time. I an using Excel 2003 on Windows XP.
Thanks very much.
 
B

Bob I

Nope, you can sort on 3 columns at a time, just keep sorting from the
least significant 3 to the most significant 3 columns.
 
B

Bob I

You do understand that you may continue the sort on additional sets of
three columns to gain additional ordering of the data.
 

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

Top