Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I'm working with a large dataset, with over 800 variables. I would like to be
able to arrange my columns alphabetically, by variable name. So, let's pretend I had only three variables, instead of 800: "cars," "boats," and "animals." These three variable names also serve as my column labels. I'd like have the three columns sorted alphabetically, so that the "animals" column appears first, then the "boats" column, then the "cars" column. Is there a way to do that? Thanks! |
#2
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
In the Sorting dialog, there is an Options button, which gives the "Sort
Left to Right" choice......... Vaya con Dios, Chuck, CABGx3 "Beatcal" wrote in message ... I'm working with a large dataset, with over 800 variables. I would like to be able to arrange my columns alphabetically, by variable name. So, let's pretend I had only three variables, instead of 800: "cars," "boats," and "animals." These three variable names also serve as my column labels. I'd like have the three columns sorted alphabetically, so that the "animals" column appears first, then the "boats" column, then the "cars" column. Is there a way to do that? Thanks! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How do I arrange names alphabetically in Excel? | Excel Discussion (Misc queries) | |||
How do you arrange text alphabetically in a column? | New Users to Excel | |||
How do I arrange the worksheets in my workbook alphabetically? | Excel Worksheet Functions | |||
arrange columns alphabetically in Excel | New Users to Excel | |||
How do I arrange entries in a column alphabetically | Excel Discussion (Misc queries) |