Find or replace data, Sort data – Unitech PA950 User Manual

Page 106

Advertising
background image

10-106

Find or replace data

1. Tap Edit > Find/Replace.

2. Enter the text you want to find and tap Find. If you're replacing text, tap

Replace and enter the replacement text.

3. Select the appropriate options.

4. Tap Find.

5. Pocket Excel selects the first instance of the text in the workbook and

displays buttons that allow you to find the next instance or replace the text,

as desired.

To limit your search to specific cells, select the cells before tapping Edit

> Find/Replace.

Sort data

1. Select the range you want to sort.

2. Tap Tools > Sort.

3. In Sort by, select the first column you want to sort on.

4. The Ascending check box is selected, indicating that the column will be

sorted in ascending order. If you want the column sorted in descending

order, tap to clear the check box.

5. Repeat steps 3 and 4 in the Then by lists for additional columns as

needed.

To undo a sort, tap Edit > Undo Sort.

Advertising