|
Finding and replacing formulas or values
You can specify in the Find & Replace dialog either to find the parts of a formula or the results of a calculation.
- To open the Find & Replace dialog, use the keyboard shortcut Control+F or select Edit > Find & Replace.
- Click More Options to expand the dialog.
- Select Formulas or Values in the Search in drop-down list.
- Formulas finds parts of the formulas.
- Values finds the results of the calculations.
- Type the text you want to find in the Search for box.
- To replace the text with different text, type the new text in the Replace with box.
- When you have set up your search, click Find. To replace text, click Replace instead.
|
|