Alphabetical List Of Columns
 

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.

Alphabetical List Of Columns
 

Data | Sort | Options | Select Left to Right
--
HTH...

Jim Thomlinson


"trip_to_tokyo" wrote:

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.

Alphabetical List Of Columns
 

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


"trip_to_tokyo" wrote:

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.

Alphabetical List Of Columns
 

But only one row at a a time.

To sort multiple rows left to right you need VBA.


Gord Dibben MS Excel MVP

On Fri, 4 Dec 2009 08:14:01 -0800, Jim Thomlinson
wrote:

Data | Sort | Options | Select Left to Right