How do I put things in alphabetical order on spreadsheets
 

Is there a way to put columns on a table in alphabetical order?

How do I put things in alphabetical order on spreadsheets
 

Have a look at Data | Sort
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email


"STLCCStudent" wrote in message
...
Is there a way to put columns on a table in alphabetical order?

How do I put things in alphabetical order on spreadsheets
 

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.





"STLCCStudent" wrote:

Is there a way to put columns on a table in alphabetical order?