YOUR MICROSOFT OFFICE AND OTHER DOCUMENT TOOLS
EXCEL MOBILE®255
11
CHAPTER
4Select Rename, enter a new name for
the worksheet, and press OK
twice.
Sorting info in a worksheet
1Highlight the cells you want to sort.
2Press Menu (right softkey) and select
Tools > Sort.
3Select the Sort by list, and then select
the primary sort column.
4Check 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.
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
1Tap and drag the stylus to highlight the
cells that contain the info you want to
filter.
2Press Menu (right softkey) and select
Too l s > AutoFilter. In each column
containing a highlighted cell, an arrow
appears on the right side of the cell
nearest the top of the column.
3Tap 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 Tool s > AutoFilter
again.
Creating a chart
1Open the workbook in which you want
to create a chart.
2Highlight 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.