| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I put things in alphabetical order on spreadsheets
Is there a way to put columns on a table in alphabetical order?
|
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| last name alphabetical order | Excel Discussion (Misc queries) | |||
| alphabetical order within a cell | New Users to Excel | |||
| Alphabetical order possible? or not | Excel Discussion (Misc queries) | |||
| why are my files out of alphabetical order? | Excel Discussion (Misc queries) | |||
| How do I put worksheets in alphabetical order | New Users to Excel | |||
Linear Mode
