Show All

Hide All

• Sort the contents of a table

• Sort a single column in a table

• Sort by more than one word or field inside a table column

Sort the contents of a table

1. In Print Layout view (Print Layout view: A view of a document or other object as it will appear when you print it. For example, items such as headers, footnotes, columns, and text boxes appear in their actual positions.), move the pointer over the table until the table move handle appears.
2. Click the table move handle to select the table that you want to sort.
3. Under Table Tools, on the Layout tab, in the Data group, click Sort.
4. In the Sort dialog box, select the options that you want.

 Top of Page

Sort a single column in a table

1. Select the column that you want to sort.
2. Under Table Tools, on the Layout tab, in the Data group, click Sort.
3. Under My list has, click Header row or No header row.
4. Click Options.
5. Under Sort options, select the Sort column only check box.
6. Click OK.

 Top of Page

Sort by more than one word or field inside a table column

To sort the data in a table that is based on the contents of a column that includes more than one word, you must first use characters to separate the data — including data in the header row. For example, if the cells in a column contain both last and first names, you can use commas to separate the names.

1. Select the column that you want to sort.
2. Under Table Tools, on the Layout tab, in the Data group, click Sort.
3. Under My list has, click Header row or No header row.
4. Click Options.
5. Under Separate fields at, click the type of character that separates the words or fields that you want to sort, and then click OK.
6. Under Sort by, in the Using list, select which word or field you want to sort by.
7. In the first Then by list, enter the column that contains the data that you want to sort by, and then in the Using list, select which word or field you want to sort by.

   If you want to sort by an additional column, repeat this step in the second Then by list.

8. Click OK.

 Top of Page