Instructions for using the Find and Replace functions in Excel

With Excel spreadsheets with large amounts of data, it is very time consuming to search and replace data cells manually. The following article details how to use the Find and Replace function in Excel.

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 .

Instructions for using the Find and Replace functions in Excel Picture 1

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

Instructions for using the Find and Replace functions in Excel Picture 2

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

Instructions for using the Find and Replace functions in Excel Picture 3

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 .

Instructions for using the Find and Replace functions in Excel Picture 4

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 want to replace all, click Replace All .

Instructions for using the Find and Replace functions in Excel Picture 5

Good luck!