How to use Find and Replace in Excel

This guide will show you how to use Find and Replace in Excel. The Find and Replace in Excel helps you to quickly search for and change specific text, numbers, or formulas in your spreadsheet. This is especially useful for fixing errors, updating old information, or making widespread changes, making it a key tool for managing and updating large amounts of data efficiently. Knowing how to use Find and Replace can save your time and improve the accuracy of your data management tasks.

How to use Find and Replace in Excel?

First let’s understand how to use Find and Replace in Excel in step by step.

Steps: How to use Find in Excel?

• Go to Home tab in the ribbon, click Find & Select and then Find button under Editing section.

• In the “Find what” box, type the text or numbers you want to search for. You can also click the arrow in the “Find what” box to choose something from your recent searches.
• Click “Find Next” to find the text or number you have entered in “Find what” box. Click again “Find Next” to find the next result.
• Click “Find All” to find all the search results.

• Click on “Options” to use the advanced find features in Excel.

Steps: How to use Replace in Excel?

• Go to Home tab in the ribbon, click Find & Select and then Replace button under Editing section.
• Or click the Replace tab in the Find window.

• In the “Find what” box, enter the text or numbers you are looking for to replace.
• In the “Replace with” box, enter the text or number you want to be reflected.

How to use Find and Replace in Excel with Example?

Suppose you want to find the text “Apple” and replace it with “Apples”, then follow the below steps to find and replace in Excel:

• Go to Home tab 〉 Find & Select 〉 Replace button under Editing section.

• In the Find what box, enter the text “Apple” to find it.
• In the Replace with box, enter the text “Apples” and click Replace All to replace all the text at a time.

• After the Excel finds the old text and replace it with new text it will show as “All done. We made x replacements.” In this example, since the Excel found 4 “Apple” in the worksheet, it made 4 replacements with “Apples”.
• Then click OK and close the Find and Replace window.

How to use Find and Replace in Excel using Shortcuts?

Below are the keyboard shortcut keys to Find and Replace in Excel:

Conclusion

Learning how to use the find and replace in Excel can make working with large datasets much easier and more accurate. This tool helps you to quickly find specific data and make many changes at once, without having to edit each one manually. Whether you’re fixing mistakes, updating info, or changing the format, the find and replace in Excel can make your changes more precise.

Learn More