Find

To find data in the current document:

1. Call the Find and Replace panel in one of the following ways:

On the Edit menu, select Find.

On the Sidebar, click the search_sidetab button.

Press Ctrl+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.

The search results will be highlighted in the document. Use the search_sidetab_nav buttons under the Find and Replace panel to move through the cells containing the search results.

Replace

To find and replace the data in the current document:

1. Call the Find and Replace panel in one of the following ways:

On the Edit menu, select Find.

On the Sidebar, click the search_sidetab button.

Press Ctrl+F.

2. If necessary, set Find and 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 fragment found.

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.

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.
Was the material useful?
Yes
No
Users found this material useful: 0 из 0