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.

Image

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 ...

Get Office 2013 In Depth now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.