Sort order of columns

[MelanieB]

A coworker has a spreadsheet with about 50 columns of data. She wants to sort the column order alphabetically.
For instance, the column titles are employee names.
Right now they are not in any particular order. It may be Smith, Jones, Allen, Bunch (columns B, C and D respectively).

How can she reoder the columns so they are alphabetical by the title?

[HansV]

Let her select the table - both the column headers and the data below them.
In Excel 2003 or before: select Data | Sort...
In Excel 2007 or later: activate the Data tab of the ribbon, then click Sort (or click Sort and Filter > Custom Sort... on the Home tab of the Ribbon).
Click the Options... button.
Specify that you want to sort left-to-right.
Click OK.
Specify that you want to sort on Row 1.
Click OK.

The screenshot below is from Excel 2007.

x381.png

[MelanieB]

Wow.. I never even looked at that options button before (2030). How cool.
Thank you!