How to Use the Find and Replace Functions in Excel

This updated guide explains how to Use the Find and Replace Functions in Excel through clear steps, practical examples, and important checks that help prevent common errors.

1. Search for Find Data

Note that the cursor should be placed at the first position of the Excel file.

Step 1: There are 2 ways for you to choose the Find function.

- Option 1: Use the key combination Ctrl + F .

- Method 2: Go to the Home tab -> Select Find & Select -> Find .

Step 2: The dialog box appears to enter keywords to search in Find What -> Find Next .

Step 3: To search for all, click Find All → Results:

2. Replace the Replace Data

Note that the cursor should be placed at the first position of the Excel file.

Step 1: There are 2 ways for you to choose the Replace function.

- Option 1: Use the key combination Ctrl + H .

- Method 2: Go to the Home tab -> Select Find & Select -> Replace .

Step 2: The dialog box appears, enter the value to be replaced in Find What , the replacement value in the Replace with section . As in the example will replace the value D01ES with D01ES. Clicking Replace button will replace each found position. If you may need to replace all, click Replace All .