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
   314   315   316   317   318   319   320   321   322   323   324