Page 286 - Trackpad IT-402_Class-IX
P. 286
To Find Formulas or Values
You can specify in the Find & 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: Click on the More Options from the Find & Replace dialog box.
Step 2: Select Formulas or Values in the Search in list box.
With Formulas, you will find all the parts of the formulas.
With Values, you will find the results of the calculations.
Step 3: Type the text you want to find in the Search for box.
Step 4: To replace the text with different text, type the new text in the Replace with box.
Step 5: When you have set up your search, click on Find. To replace text, click on Replace instead.
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 & Replace dialog box, click on More Options, and select Values or Notes in the Search in
drop-down list.
Step 2: Type the text you want to find in the Search for box.
Step 3: To replace the text with different text, type the new text in the Replace with box.
Step 4: Click on Find, Find All, Replace, or Replace All.
When you click on Find, Calc selects the next cell that contains your text. You can edit the text, and then click on Find
again to advance to the next found cell. If you closed the dialog box, you can press Ctrl+Shift+F to find the next cell
without opening the dialog box.
When you click on Find All, Calc selects all cells that contain your entry. Now you can, for example, apply a cell style
to all at once.
286 Trackpad Information Technology-IX

