Excel - How do I put things in alphabetical order on spreadsheets

Asked By STLCCStudent on 01-Nov-09 02:00 PM
Is there a way to put columns on a table in alphabetical order?




Bernard Liengme replied on 01-Nov-09 02:11 PM
Have a look at Data | Sort
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email
Old in Dallas replied on 01-Nov-09 07:22 PM
Convert the columns to rows with the Edit - Paste Special - Transpose
function, then do the sort and reverse the process. Select all, then Ctrl-C,
then on the destination cell, make sure you right click to see the option
down at the bottom for Transpose.