Word 2016 Intermediate

Word 2016

Lesson 8 – Sorting Table Data

Click anywhere in the document to deselect the table. Notice that the items in the table are sorted numerically by the Retail Price column in descending order.

Practice the Concept: Click anywhere in the table then, select the Sort button in the Data group. Select the Sort by list and choose Order Number . Notice that the criterion in the Type box has changed to Text ; this is because the Retail Price column contains values that combine numbers and text. Click OK then, deselect the table.

Then, sort the table again by the Retail Price column in descending order.

S ORTING A T ABLE BY D ATE  D ISCUSSION

You can sort a table by a column containing dates. The dates can be formatted with any of the available date formats (such as, September 27, 2007 ; 9/27/07 ; 27-Sept-07 ; and Sept-27-07 ).

To sort the entire table, you can position the insertion point anywhere in the table. If, however, one or more rows are selected when you perform the sort, only the selected rows are sorted.  P ROCEDURES 1. Position the insertion point anywhere in the table you want to sort. 2. Select the Layout contextual tab on the Ribbon .

3. In the Data group, select the Sort button . 4. Under My list has , select the desired option based on whether the table has a header row.

5. Select the Sort by list . 6. Select the column by which you want to sort. 7. Select the Ascending or Descending option, as desired.

8. Select

.

S TEP - BY -S TEP

Sort a table by date.

OFFICEPRO, Inc.

Page 141

Made with FlippingBook - professional solution for displaying marketing and sales documents online