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

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.