Sorting

N

Nicole H.

I am trying to sort alphabetically a list of job names with their
corresponding address, however, I haven't been able to figure out how to do
this without Excel moving columns around or even leaving out certain columns
that belong to the same row of information. For example,

Daniels Building Construction Company - one column
P.O. Box 1234 - separate column in the same row
Los Angeles - separate column in the same row
CA - separate column in the same row

When I try sorting A-Z Excel will move the address (the PO box) to the first
column and sort the Job name (Daniels Building...) alphabetically.

What am I doing wrong?
 
E

Eduardo

Hi,
You have to highlight the whole range ( all columns), then sort by the
column where the names are for example

names are in column A, and you have information up to column R row 100
so you select from A1 to R100 and then sort by column A
 

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