Page 319 - TP_IT_V1.0_C9_flipbpookl
P. 319
You can navigate from one result to the next by using the Find Next button, you can highlight one result to the previous
by using the Find Previous button or you can highlight all matching cells at once by using the Find All button, then
apply another format or replace the cell contents by other content. The Replace button is used to replace the currently
found occurrence and find the next. The Replace All button replaces all occurrences in the spreadsheet.
To Find Formulas or Values
You can specify in the Find and Replace dialog box either to find the parts of a formula or the results of a calculation.
To do so, follow the given steps:
Step 1: Open the Find and Replace dialog box.
Step 2: Click on the Other options in the Find and Replace dialog box.
With Formulas, option, you will find all the parts of the
formulas. With the Values option, you will find the results of the
calculations.
Step 3: Select Formulas in the Search in list box.
Step 4: Type the formula that you want to find in the Find box.
Step 5: Type the new formula in the Replace box by which the
formula is replaced.
Step 6: Click on the Find Next button to search for the formula.
Step 7: Click on the Replace button to replace the formula.
Cell contents can be formatted in different ways. For example, a
number can be formatted as a currency, to be displayed with a
currency symbol. You see the currency symbol in the cell, but you
cannot search for it.
Finding and Replacing Text
To find and replace text, follow the given steps:
Step 1: Open the Find and Replace dialog box.
Step 2: Click on the Other options in the Find and Replace dialog box.
Step 3: Select Values in the Search in list box.
Step 4: Type the value that you want to find in the Find box.
Step 5: Type the new value in the Replace box.
Step 6: Click on the Find Next, Find Previous, Find All, Replace, or Replace All button.
If you closed the dialog box, you can press Ctrl+Shift+F to find the next cell without opening the dialog box.
Electronic Spreadsheet 317

