Filter
Top Products
YOUR MICROSOFT OFFICE AND OTHER DOCUMENT TOOLS
EXCEL MOBILE
®
255
11
CHAPTER
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
To o ls > 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 To ol s > 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.