Finding and Replacing Cell Content

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



To replace all instances of a word in a worksheet:

  1. Select Replace... from the Edit menu.
  2. Type the word or phrase you wish to change in the Find what: box.
  3. Type the desired text in the Replace with: box.
  4. Click Replace All.
  5. Click OK on the message that appears; then click Close in the Find and Replace dialog box.


In addition to text, Find and Replace can also operate on formatting characters such as italicized text and paragraph marks. The Options button in the Find and Replace dialog box allows you to search by rows, columns, or within worksheets.

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

  1. Find = +
  2. Replace = +