Palm Treo 700VVX, User Manual

Page: 218 / 348

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
218
11
CH
AP
T
E
R
Renaming a worksheet
1 Open the workbook containing the
worksheet you want to rename.
2 Press Menu (right softkey) and
select Format > Modify Sheets .
3 In the Sheets list, highlight the
worksheet you want to rename.
4 Select Rename , enter a new name for
the worksheet, and then 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 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 then
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.
DID YOU KNOW
?
You can adjust the column and
row size by tapping and dragging the right
edge of the column or the bottom edge of the
row. To automatically fit rows and columns to
their contents, double-tap the lower edge of
the row heading or the right edge of the
column heading.