Palm 750 manual 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 T O O L S

10

2Press Menu (right action key)) and select Format > Modify Sheets.

3In the Sheets list, highlight the worksheet you want to rename.

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

Sorting info in a worksheet

1Highlight the cells you want to sort.

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

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

4Check or uncheck the Ascending box to indicate if you want to sort in ascending or descending 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

1Highlight the cells that contain the info you want to filter.

2Press Menu (right action key) and select Tools > AutoFilter. A list appears at the top of each related column.

3Select one of the new lists, and then select a filter. This hides all rows that do not include the selected filter.

4(Optional) Do any of the following:

•Select the other lists, and then select other filters.

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

•To turn off filtering, press Menu and select Tools > AutoFilter again.

DID YOU KNOW? You can also create custom filters where you specify comparisons. Select the filter lists, and then select Custom.

Creating a chart

1Open the workbook you want to create a chart from.

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 181