Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.newusers
|
|||
|
|||
![]()
Sup!
I always wonder if there is a way 2 make a list of names in ABC order. Example: A1 to A30 has a list of names not in ABC order, How do I make the Colum A in ABC order without typing the names all over again? |
#2
![]()
Posted to microsoft.public.excel.newusers
|
|||
|
|||
![]()
One way:
Select A1:A30. Choose Data/Sort... from the menu. In article , QueenElizabeth wrote: Sup! I always wonder if there is a way 2 make a list of names in ABC order. Example: A1 to A30 has a list of names not in ABC order, How do I make the Colum A in ABC order without typing the names all over again? |
#3
![]()
Posted to microsoft.public.excel.newusers
|
|||
|
|||
![]()
Hi,
Just select the cells which you want to sort and then click the button Sort Ascending for Ascending order and Click Sort descending for Desending order in the toolbar. Note: You can use this if there is no dependency column for the column which you are going to sort. If there is any dependency column, then select that column also and then sort. So that the columns which are dependable also will get modify accordingly. Hope this will clear your doubt. Regards, Soundar "QueenElizabeth" wrote: Sup! I always wonder if there is a way 2 make a list of names in ABC order. Example: A1 to A30 has a list of names not in ABC order, How do I make the Colum A in ABC order without typing the names all over again? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How do I join text from 2 cells, and make them appear in 2 lines | Excel Discussion (Misc queries) | |||
Make text cells and combo boxes required? | Excel Discussion (Misc queries) | |||
Make Existing Data In Cells Text | Excel Worksheet Functions | |||
Make Cells Text | Excel Worksheet Functions | |||
Can I concatenate text in cells to make a working formula? | Excel Discussion (Misc queries) |