Saturday, June 11, 2011

How to Sort Alphabetically in Excel


1. Create your spreadsheet using the Microsoft Excel columns. Place the names you want organized in one column, with one name in each cell. In the soccer example, you could list them 'Last name, First name,' such as in this example: 'Robbins, Johnny,' 'Ferguson, Anne,' and so on.
2. Select a cell from the column you want to organize alphabetically by left-clicking. The soccer spreadsheet will be organized by last names, and you could click 'Robbins, Johnny,' 'Ferguson, Anne,' or any of the listed names.
3. Choose the 'Sort A to Z' button to sort in ascending alphanumeric order or the 'Sort Z to A' button to sort in descending alphanumeric order in the top task bar. If you chose 'Robbins, Johnny' in the soccer example and clicked the 'Sort A to Z button', it would sort: 'Adams, Douglas,' as the first name and 'Zahn, Monty' as the last name and 'Robbins, Johnny,' somewhere in between.

Blogger news