Once you have entered data into a table, you can reorganize it in alphabetical or numerical order. For example, you may want to sort a list of customers alphabetically by last name or numerically by sales. Excel allows you to sort by in either ascending (A to Z for alphabetical data, smallest to largest for numbers and oldest to most recent for date) or descending (Z to A for alphabetical data, largest to smallest for numbers and most recent to oldest for dates) order.
To quickly sort a single column of data in a table, click anywhere in the column that you wish to sort and click the Sort Ascending or Sort Descending button on the Sort & Filter group on the Data Ribbon. Excel will sort all of the data in the selected column, as well as the other columns in your table so that all of your rows are sorted correctly.
To Sort a Table in Excel
- Click anywhere in the column that you wish to sort.
- Click the Data tab on the Ribbon.
- Click the Sort Ascending or Sort Descending button on the Sort & Filter group on the Data Ribbon.