Sorting is a common spreadsheet task that allows you to easily reorder your data. The most common type of sorting is alphabetical ordering, which you can do in ascending or descending order.
To sort in alphabetical order :
- Select a cell in the column you want to sort (In this example, we choose a cell in column A).
- Click the Sort & Filter command in the Editing group on the Home tab.
- Select Sort A fo Z. NOWT the information in the Category column is organized in alphabetical order.