sorting multiple columns

[arbe]

I have multiple addresses on a work sheet. I need to have all the same zip
code # together. How do I sort them by zip code so right name and address
ends up with right zip code

 

[Fred Smith]

Highlight the range you want to sort before starting it.

Regards,
Fred

 

[Gord Dibben]

Pre-select all the columns before sorting on Zip Code.


Gord Dibben MS Excel MVP