10-107
Filter data
1.
Select a cell that contains the type of information you want to filter, or select
the range.
2.
Tap
Tools
>
AutoFilter
.An arrow appears at the top of each of the selected
columns.
3.
Tap an arrow in one of the columns.
4.
Select a value (filter criterion) from the list to display only rows containing
that value. Tap
Custom
to display the
Custom AutoFilter
dialog box,
where you can specify comparisons.
5.
To further refine the displayed rows, repeat steps 3 and 4 as needed.
To turn off AutoFilter, tap
Tools
>
AutoFilter
.
To display all rows again, select
All
from the filter list in each of the
selected columns.
Edit and Format Data
Edit cell contents
Copy and paste
Delete a row or column
Format numbers and text
Insert symbols
Edit cell contents
1.
Select the cell.
2.
To activate, tap the formula bar at the top of the worksheet.
3.
Replace or edit the contents.
4.
Tap ENTER in the input panel to enter the changes in the cell.
To undo an action, tap
Edit
>
Undo Typing in
x.
See Also:
Format numbers and text
