Office 2013 In Depth

Sorting Table Data

Sorting by the fields in a table enables you to quickly place the records in the table based on your sort criteria. You can sort data by using the sort commands on a field’s AutoFilter menu or by selecting one of the Sort commands in the Sort & Filter group on the Ribbon’s Data tab. To quickly sort the table by a particular field, select that field’s AutoFilter arrow, as shown in Figure 15.4.

Figure 15.4. The AutoFilter menu for a table field.

You can then select Sort A to Z (ascending) or Sort Z to A (descending) as needed on the AutoFilter menu. The records in the table are sorted by the field you selected in the direction ...