Sort the contents of a table

  1. In Print Layout view, move the pointer over the table until the table move handle four-headed arrow handleappears.
  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.

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.

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.