Alphabetical List Of Columns

[trip_to_tokyo]

If I have a list of columns can I perform a Sort that will arrange those
columns aphabetically (and then save them in that alpha order)? I think that
the answer is no (however I could think of times when this would be useful).
Thanks in advance for any replies.

 

[Jim Thomlinson]

Data | Sort | Options | Select Left to Right

 

[dlw]

not sure what you mean by "list of columns" but any list in excel can be
sorted by highlighting the list and going data > sort

 

[Gord Dibben]

But only one row at a a time.

To sort multiple rows left to right you need VBA.


Gord Dibben MS Excel MVP