Sorting multiple colums ???

D

Drew Leyda

I have a 5 column worksheet.
I want to sort the first column A to Z
Then, without changing the first column, I want to sort the second column A to Z.
I have read the Help page but I can not seem to "select" the columns.
Help ......
TIA
Drew
 
E

Eduardo

Hi,
if excel 2007
select the whole range, then go to sort, sort by column A, Add Level and
there choose the second column you want to sort, add level ...

if this helps please click yes, thanks
 

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

Similar Threads

MS Project Center-Autolink column fields 0
Split cells next to 1 cell 1
excel 2011 won't sort alphabetically 7
Mail Merge query 1
Consolidation Table from Different Excel Tabs with Different Format 1
Sorting rows 16
Need Help with a VBA subroutine 0
How can I sort "oldest to newest?" 5

Top