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?
Sort order of columns
-
- 3StarLounger
- Posts: 310
- Joined: 19 Apr 2010, 16:18
- Location: middle of the state of Washington
-
- Administrator
- Posts: 78788
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: Sort order of columns
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.
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.
You do not have the required permissions to view the files attached to this post.
Best wishes,
Hans
Hans
-
- 3StarLounger
- Posts: 310
- Joined: 19 Apr 2010, 16:18
- Location: middle of the state of Washington
Re: Sort order of columns
Wow.. I never even looked at that options button before (2030). How cool.
Thank you!
Thank you!