Find and Replace Features in Excel (Using the Replace Feature)

The Replace feature is useful when you want to change the same piece of information throughout your worksheet.
WARNING: Use the Replace All option with caution. If you do not first select specific cells to change, this option will replace the specified information throughout the entire document. This can change the meaning of your document if text is replaced where it should not be.

1.      OPTIONAL: If you want to find and/or replace information in a specific section of your document, select the desired portion of the document
HINTS:
To select contiguous cells, click the desired cells
To select non-contiguous cells, hold down [Ctrl] + click the desired cell(s)

2.      In the Editing group, click FIND & SELECT» select Replace...
OR
Press [Ctrl] + [H]
The Find and Replace dialog box appears.

3.      In the Find what text box, type the text or data to be found

4.      In the Replace with text box, type the text or data to replace the information found

5.      OPTIONAL: Adjust the searching options

6.      Click FIND NEXT
The first occurrence is highlighted.

7.      To replace only that occurrence, click REPLACE
To replace all occurrences, click REPLACE ALL
The old information is replaced with the new.
WARNING: Use the Replace All option with caution. If you do not first select specific cells to change, this option will replace the specified information throughout the entire document. This can change the meaning of your document if text is replaced where it should not be.

8.      To find and replace additional instances of your text or data, repeat steps 6–7

9.      To close the dialog box, click CLOSE

Related Posts by Categories