To sort the contents of a table, first click inside the table to show Table Tools in the ribbon and then click Layout > Sort.
You’ll see the Sort dialog box.
In the dialog box, choose how you’d like to sort the table and click OK.
- Under Sort by, choose the name of the column you want to sort the table by.
- Next to Type, choose if you’d like to sort according to Text, Number, or a Date.
- Click next to Ascending or Descending to choose a sort order.
- If the column you’re sorting contains fields of information separated by commas, tabs or some other character, click next to Using to choose which field to sort by. For example, if the column you’re sorting is Last name, First name, you can choose to sort by Last name or First name. Click the Options button at the bottom of the dialog box to choose the separating character.
- If you want to have a second level sort, you can enter that information under Then by. The second level sort will only take effect if two or more values in the first column are the same.
- You can also choose a third level sort.
- If your table has a header row, be sure to click the Header row box at the bottom of the dialog box. That way, the top row will not be sorted and will stay at the top.
- Click Options for additional settings, such as making your sort case sensitive or choosing the sort language.
You can also sort text in a list that's not in a table.