Tip: Video not in your language? Try selecting Closed Captioning .
When your table contains data that would be better presented in alphabetical or numerical order, sort it.
Select anywhere in the table.
Select Table Tools Layout > Sort.
Note: In Excel, select Home > Sort & Filter > Custom Sort.
Choose your sorting criteria.
To choose a sort order, select Ascending or Descending.
To sort on a second column, enter that information for Then by.
Note: In Excel, select Add Level and then enter the information. The second level sort only takes effect if two or more values in the first column are the same.
If your table has a header row, select Header row or My data has headers and then select OK.
Tip: In Excel, to sort A–Z, Z–A, lowest to highest, or highest to lowest, select a cell in the column to sort by, select Sort & Filter, and then select a sort option.
If you’re working with data in a table, sort it to best present your content.
To sort data in Word, select anywhere in the table and select Table Tools Layout.
And then select Sort.
Now choose your sorting criteria.
To put your data in Ascending order and keep the header row at the top of the table, make sure that Header row is selected.
And then select OK.
To sort a column in Excel, select it, select Sort & Filter, and then select how you’d like to order it.
You can also select Custom Sort, and then select your sort criteria.
To set additional filters, select Add Level.