ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   New Users to Excel (https://www.excelbanter.com/new-users-excel/)
-   -   make text in cells in ABC order (https://www.excelbanter.com/new-users-excel/161446-make-text-cells-abc-order.html)

QueenElizabeth

make text in cells in ABC order
 
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?

JE McGimpsey

make text in cells in ABC order
 
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?


Soundar

make text in cells in ABC order
 
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?



All times are GMT +1. The time now is 03:24 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com