| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sorting columns alphabetically
I have a spreadsheet that has names starting in B2 through DH2. I want to
sort B2 through DH2 alphabetically, while keeping the information through row 108 with the corresponding name. Is that possible? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Sorting columns alphabetically
SueG wrote:
I have a spreadsheet that has names starting in B2 through DH2. I want to sort B2 through DH2 alphabetically, while keeping the information through row 108 with the corresponding name. Is that possible? Select your range. Select Data / Sort / Options and under Orientation select "sort left to right". |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Sorting columns alphabetically
Thank you very much!!!!
"Glenn" wrote: SueG wrote: I have a spreadsheet that has names starting in B2 through DH2. I want to sort B2 through DH2 alphabetically, while keeping the information through row 108 with the corresponding name. Is that possible? Select your range. Select Data / Sort / Options and under Orientation select "sort left to right". |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Sorting columns alphabetically
Hi
copy range B2:DH108, in an unused sheet select A1, goto "Edit" Paste Special Check "Transpose" OK Sort the range. Now repeat the steps above to paste the sorted data into the original place. Hopes it helps. Regards, Per "SueG" skrev i meddelelsen ... I have a spreadsheet that has names starting in B2 through DH2. I want to sort B2 through DH2 alphabetically, while keeping the information through row 108 with the corresponding name. Is that possible? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I arrange columns alphabetically by column label? | Excel Worksheet Functions | |||
| Sorting Alphabetically | Excel Discussion (Misc queries) | |||
| Sorting data in a cell alphabetically | Excel Worksheet Functions | |||
| Sorting multiple columns as 1 list alphabetically? | Excel Discussion (Misc queries) | |||
| arrange columns alphabetically in Excel | New Users to Excel | |||
Hybrid Mode
