Try it!
When your table contains data that is best presented in alphabetical or numerical order, sort it.
Note:Â These instructions are for Word and Excel. The sort option is not available in PowerPoint.
Sort a table in Word
-
Select anywhere in the table.
-
On the Table Layout tab, select Sort.
-
Choose your sort criteria:
-
Select the column you want to Sort by.
-
To sort on a second column, select Then by and select another column.
-
Select Ascending or Descending.
-
To keep the header row at the top of the table, select Header row.
-
-
Select OK.
Note:Â If you get a "This entry is not valid for sorting" error, select the drop down under Sort by and choose a column or header.
Sort a table in classic Outlook
-
In a message, select anywhere in the table.
-
On the Table Layout tab, select Sort.
-
Choose your sort criteria:
-
Select the column you want to Sort by.
-
To sort on a second column, select Then by and select another column.
-
Select Ascending or Descending.
-
To keep the header row at the top of the table, select Header row.
-
-
Select OK.
Note:Â If you get a "This entry is not valid for sorting" error, select the drop down under Sort by and choose a column or header.
Sort a table in Excel
-
Select a cell in the column you want to sort.
-
On the Home tab, select Sort & Filter.
-
Select how you'd like to order it: Sort A to Z, Sort Z to A, or Custom Sort.
For a Custom Sort:
-
Choose your Sort by, Sort on, and Order sort criteria.
-
To set additional filters, select Add Level and choose your sort criteria.
Important:Â The second level sort only takes effect if two or more values in the first column are the same.
-
Select OK.
-
