Filtering info in a worksheet, Creating a chart – Palm 700wx User Manual

Page 159

Advertising
background image

S T A Y I N G P R O D U C T I V E

E X C E L M O B I L E

151

7

CH

AP

T

E

R

4 Check or uncheck the Ascending box to

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

6 Check or uncheck the Exclude header

row from sort box to indicate whether
you want to sort the header row.

7 Press OK

.

Filtering info in a worksheet

1 Highlight the cells that contain the info

you want to filter.

2 Press Menu

(right action key) and

select Tools > AutoFilter. A list appears
at the top of each related column.

3 Select one of the new lists, and then

select a filter. This hides all rows that do
not include the selected filter.

4 (Optional) Select the other lists, and

then select other filters.

Creating a chart

1 Open the workbook you want to create

a chart from.

2 Highlight the cells you want to include

in the chart.

3 Press Menu

(right action key) and

select Insert > Chart.

4 Select the type of chart, and then press

Next

(right action key).

5 Confirm the area you want the chart to

include, and then press Next

(right action key).

6 Select the data layout, and then press

Next

(right action key).

7 Check the boxes to indicate whether

the first row and column represent
labels.

DID

YOU

KNOW

?

You can also create custom

filters where you specify comparisons. Select
the filter list, and then select Custom.

TIP

To display all rows again, select the filter

lists, and then select All. To turn off filtering,
press Menu and select Tools > AutoFilter
again.

Advertising