You can't.

Go back to your original data and sort again, but next time ensure that you
select the full range (columns and rows) before you ask Excel to sort. It
is unwise to allow Excel to guess what you want sorting, as you have
discovered.
--
David Biddulph

"Quiche" wrote in message
...
I created an excel spreadsheet for database information.
I have 7 columns
The first 4 columns are in order by last name, with matching title, and
organization, as they should be.
However, in doing some sorting of zip codes, I now have the last 3 columns
which include the addresses city, state and zip code in their proper order
(matching) however, they now do not match with the first 3 columns.

How can I put them back in the right order to match?