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
   281   282   283   284   285   286   287   288   289   290   291