Palm PMG0501000P, Руководство пользователя

Страница: 255 / 398

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
E X C E L M O B I L E
® 255
11
CH
AP
T
E
R
4 Select Rename , enter a new name for
the worksheet, and press OK
twice.
Sorting info in a worksheet
1 Highlight the cells you want to sort.
2 Press Menu (right softkey) and select
Tools > Sort .
3 Select the Sort by list, and then select
the primary sort column.
4 Check 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.
6 Check or uncheck the Exclude header
row from sort box to indicate whether
you want to sort the header row.
7 Select OK .
Filtering info in a worksheet
1 Tap and drag the stylus to highlight the
cells that contain the info you want to
filter.
2 Press 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.
3 Tap 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.
Creating a chart
1 Open the workbook in which you want
to create a chart.
2 Highlight the cells you want to include
in the chart.
DID YOU KNOW
?
You can also create custom
filters where you specify comparisons. Open
a filter list and select
Custom .