Up next in How to Use Computer Software (38 videos)
Learn how to use computer software, like how to get zip files, with this Howcast video series.
You Will Need
- Microsoft Excel
- Data to be alphabetized
Select a row or column
Click a cell in the column or row you would like to sort.
Open the Sort window
Under the Data tab, in the Sort & Filter group, click Sort. This brings up the Sort window in Excel 2007.
Open the Options sub-window
Click on Options in the Sort window. In the Options sub-window, select Sort top to bottom to sort columns, Sort left to right to sort rows, or select Case Sensitive to sort by case.
Make selections in the Sort window
Select the column or row header for the column or row you would like to alphabetize. For Excel 2007, select Values in the Sort On box, then select A to Z to sort in ascending order or Z to A to sort in descending order.
Click OK to close the Sort window and begin alphabetizing.