Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sorting
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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sorting
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 "Nicole H." wrote: 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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sorting Values Without Sorting Formulas | Excel Discussion (Misc queries) | |||
Automatic sorting (giving max and min) based on custom sorting lis | Excel Worksheet Functions | |||
Sorting VLookup vs Sorting SumProduct | Excel Discussion (Misc queries) | |||
Sorting: Sorting by the First Character | Excel Discussion (Misc queries) | |||
Sorting | Excel Worksheet Functions |