Palm PMG0501000P Sorting info in a worksheet, Filtering info in a worksheet, Creating a chart

Y O U R M I C R O S O F T O F F I C E A N D O T H E R D O C U M E N T T O O L S

11

4Select Rename, enter a new name for the worksheet, and press OK twice.

Sorting info in a worksheet

1Highlight the cells you want to sort.

2Press Menu (right softkey) and select Tools > Sort.

3Select the Sort by list, and then select the primary sort column.

4Check the Ascending box to sort in ascending (A–Z or 0–9) order. Leave the box unchecked to sort in descending (Z– A or 9–0) order.

5(Optional) Select the Then by lists, and then select second- and third-level sorting options.

6Check or uncheck the Exclude header row from sort box to indicate whether you want to sort the header row.

7Select OK.

Filtering info in a worksheet

1Tap and drag the stylus to highlight the cells that contain the info you want to filter.

2Press Menu (right softkey) and select Tools > AutoFilter. In each column containing a highlighted cell, an arrow appears on the right side of the cell nearest the top of the column.

3Tap the arrow to open a list and select a filter. This hides all rows that do not include the selected filter.

4(Optional) Do any of the following:

•Open the other lists, and select other filters.

•To display all rows again, open the filter lists and select All.

•To turn off filtering, press Menu (right softkey) and select Tools > AutoFilter again.

DID YOU KNOW? You can also create custom filters where you specify comparisons. Open a filter list and select Custom.

Creating a chart

1Open the workbook in which you want to create a chart.

2Highlight the cells you want to include in the chart.

C H A P T E R

E X C E L M O B I L E ® 255