Change sort order

(upbeat music)…- [Narrator] If you want your data to be…in alphabetical order or some other specific order,…try the sort tool.…Select a column in your sheet.…In the home ribbon, go to sort and filter.…To sort alphabetically, choose sort A to Z.…I can choose to keep my data intact by allowing it…to expand and sort everything using the column…I selected to determine the order.…

If I choose continue with the current selection,…it will sort only the column I selected.…Excel recognized that the first row contained…heading labels, so it was not included in the sort.…The column that I selected is now in alphabetical order,…and all of the other data was sorted to match.…If you want to set a different criteria for sorting,…go to the sort and filter menu and choose custom sort.…