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

10-107

Page 107
Image 107
Unitech PA950 manual Edit and Format Data, Filter data, Edit cell contents