Finding and Replacing Formatting in Cells

The Find and Replace commands can be used to locate formatting in a document. Find and Replace allows you to find specific instances of formatting and replace them with different formatting, either one instance at a time or automatically throughout the document.



To find and replace formatting:

  1. Select Replace... from the Edit menu.
  2. Click the Options button.
  3. Click the Format... button next to the Find what: box and select the format you want to find.
  4. Click the Format... button next to the Replace with: box and select the format you want to use.
  5. Click Replace All.
  6. Click OK on the message that appears; then click Close on the Find and Replace dialog box.


The following keyboard shortcuts can be used to apply the Find and Replace commands:

  1. Find = +
  2. Replace = +