How to Use Find and Replace in Excel Quickly and Easily

In Excel, use Ctrl + F to open the Find dialog to locate specific text or numbers. To replace data, press Ctrl + H to open the Replace dialog, enter the text to find and the replacement text, then click Replace or Replace All.

Syntax

The Find and Replace feature in Excel does not use formulas but works through dialog boxes accessed by keyboard shortcuts or the ribbon.

• Find: Press Ctrl + F to open the Find dialog where you enter the text or number to locate.
• Replace: Press Ctrl + H to open the Replace dialog where you enter the text to find and the text to replace it with.
• Options: You can choose to match case, match entire cell contents, or search within formulas or values.

excel

Ctrl + F  (Open Find dialog)
Ctrl + H  (Open Replace dialog)

Example

This example shows how to replace all occurrences of the word "apple" with "orange" in a worksheet.

excel

1. Press <code>Ctrl + H</code> to open the Replace dialog.
2. In the "Find what" box, type: apple
3. In the "Replace with" box, type: orange
4. Click "Replace All" to change all instances at once.

Output

All cells containing "apple" are changed to "orange".

Common Pitfalls

• Not selecting the correct search scope (Sheet vs Workbook) can cause missed replacements.
• Forgetting to check "Match case" or "Match entire cell contents" can lead to unintended replacements.
• Replacing without previewing can change data you didn't want to alter.

Always use Find Next to review before replacing if unsure.

excel

Wrong way:
- Replace "cat" with "dog" without checking options, changing "catalog" to "dogalog" unintentionally.

Right way:
- Check "Match entire cell contents" to replace only cells exactly equal to "cat".

Quick Reference

Action	Shortcut	Description
Open Find dialog	Ctrl + F	Search for text or numbers in the worksheet
Open Replace dialog	Ctrl + H	Find and replace text or numbers
Find Next	Shift + F4	Go to the next found item
Replace	Alt + R	Replace the current found item
Replace All	Alt + A	Replace all found items at once

Key Takeaways

Use Ctrl + F to find and Ctrl + H to replace text or numbers in Excel.

Always check options like 'Match case' to avoid unwanted replacements.

Use 'Replace All' carefully to change all instances at once.

Preview replacements with 'Find Next' before replacing to avoid mistakes.

You can search within the current sheet or entire workbook.