Finding and Replacing Cell Contents

Finding and Replacing Cell Contents

The Find and Replace commands make it easy to locate or replace specific text or formulas in a document. For example, you might want to find each figure reference in a long report to verify that the proper graphic appears. Or you might want to replace all references to cell A3 in your Excel formulas with cell G3. The Find And Replace dialog boxes vary slightly from one Office program to the next , but the commands work essentially in the same way.

Find Cell Contents

Click at the beginning of the worksheet.

Click the Edit menu, and then click Find.

Type the text you want to find.

Click Find Next until the text you want to locate is highlighted.

You can click Find Next repeatedly to locate each instance of the cell content.

If a message box opens when you reach the end of the worksheet, click OK.

Click Close.

Replace Cell Contents

Click at the beginning of the worksheet.

Click the Edit menu, and then click Replace.

Type the text you want to search for.

Type the text you want to substitute.

Click Find Next to begin the search, and then select the next instance of the search text.

Click Replace to substitute the replacement text, or click Replace All to substitute text throughout the entire worksheet.

You can click Find Next to locate the next instance of the cell content without making a replacement.

If a message box appears when you reach the end of the worksheet, click OK.

Click Close.