Sorting data in a worksheet can help you find values easily, where you can rearrange a range or table of data based on one or more data columns. For example, you can sort the names of your team from A to Z.
1. Highlight the data that you want to sort.
2. Click on the Data tab in the top ribbon, followed by Sort.
3. You can then sort the data alphabetically, from A to Z, or from Z to A. You can also select Custom Sort to fine-tune your choices.