Sorting

Q

Quiche

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?
 
D

David Biddulph

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.
 

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