ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   New Users to Excel (https://www.excelbanter.com/new-users-excel/)
-   -   How to alphabetize my created list? (https://www.excelbanter.com/new-users-excel/21101-how-alphabetize-my-created-list.html)

helpanewbie

How to alphabetize my created list?
 
I am not very computer literate so I will need step by step instructions how
to create a list then alphabetize it. Thanks

Kassie

I take it you want to do this in Excel.
I do not know what information you want to record, but here goes:

If you want to create an address list for example, the type the following
headings in Row 1:
Col A: Surname
Col B: Name
Col C: Number
Col D: Street
Col E: Suburb
Col F: City
Col G: Tel
Col H: Fax
Col I: Cell
Col J: Email Address
Now start entering data.
When done, select from A1 to J whatever.
Click on Data|Sort
Make sure that Header Row is ticked
Select heading by which to sort. It will default to Surname in this case.
If you also want to sort by say city, then select this as an additional sort
criteria
Hit OK and your list is sorted


"helpanewbie" wrote:

I am not very computer literate so I will need step by step instructions how
to create a list then alphabetize it. Thanks


etakathy

THANK YOU FOR TAKING TIME TO HELP ME, KASSIE.

"Kassie" wrote:

I take it you want to do this in Excel.
I do not know what information you want to record, but here goes:

If you want to create an address list for example, the type the following
headings in Row 1:
Col A: Surname
Col B: Name
Col C: Number
Col D: Street
Col E: Suburb
Col F: City
Col G: Tel
Col H: Fax
Col I: Cell
Col J: Email Address
Now start entering data.
When done, select from A1 to J whatever.
Click on Data|Sort
Make sure that Header Row is ticked
Select heading by which to sort. It will default to Surname in this case.
If you also want to sort by say city, then select this as an additional sort
criteria
Hit OK and your list is sorted


"helpanewbie" wrote:

I am not very computer literate so I will need step by step instructions how
to create a list then alphabetize it. Thanks


Kassie

My pleasure and privilege. Hope it helped

"etakathy" wrote:

THANK YOU FOR TAKING TIME TO HELP ME, KASSIE.

"Kassie" wrote:

I take it you want to do this in Excel.
I do not know what information you want to record, but here goes:

If you want to create an address list for example, the type the following
headings in Row 1:
Col A: Surname
Col B: Name
Col C: Number
Col D: Street
Col E: Suburb
Col F: City
Col G: Tel
Col H: Fax
Col I: Cell
Col J: Email Address
Now start entering data.
When done, select from A1 to J whatever.
Click on Data|Sort
Make sure that Header Row is ticked
Select heading by which to sort. It will default to Surname in this case.
If you also want to sort by say city, then select this as an additional sort
criteria
Hit OK and your list is sorted


"helpanewbie" wrote:

I am not very computer literate so I will need step by step instructions how
to create a list then alphabetize it. Thanks



All times are GMT +1. The time now is 09:43 PM.

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