tableWeb version

Find and replace

Product: MyOffice Professional, MyOffice Private Cloud

Application: Spreadsheet Web version

Find

To find data in the current document:

1. Call the Find & Replace pane in one of the following ways:

•On the Sidebar, click the search_sidetab button.

•On the Edit menu, select Find & Replace (not available in documents available to the user for viewing only).

•Press Ctrl+F ( command Cmd+F).

2. If necessary, set the search parameters.

3. Enter the data you want to find in the Find box.

The search segment should not exceed 255 characters.

To move between the search results, do one of the following:

•On the search pane, click knpk_next Previous and knpk_1next Next.

•Use the keyboard shortcuts: Shift+Enter ( command Cmd+ return Return) to go to the previous occurrence and Enter ( return Return) to go to the next occurrence.

Replace

The text in the Replace box should not exceed 255 characters. You cannot replace numbers that are parts of a formula or partially replace numbers in two- or more digit numbers.

To find and replace the data in the current document:

1. Call the Find & Replace pane in one of the following ways:

•On the Sidebar, click search_sidetab .

•On the Edit menu, select Find & Replace.

•Press Ctrl+F ( command Cmd+F).

2. If necessary, set Find & Replace parameters.

3. Enter the data you want to find in the Find box.

4. Enter the data you want to use to replace the search text or leave it blank to delete the text found.

5.Replace the data in one of the following ways:

•Select Replace to replace the data in the selected range.

•Select Replace all to replace the text in all fragments found at a time.

Check the Match case when replacing box so that the fragments retain the original case when replacing.

In documents available to the user for viewing only, the replace function is not available.

Was this helpful?

Yes