Using Find & Replace
Search for specific data and quickly correct or replace repeated content throughout a worksheet or workbook.
Video
Watch the lesson video, then complete the reading and challenge.
Lesson Notes
Read through the key concepts before you try the challenge.
Why Use Find & Replace?
When working with large datasets, manually scanning for errors or repeated values can be time-consuming. Excel’s Find and Replace tools allow you to quickly locate and update content across a worksheet or an entire workbook.
Using the Find Command
To locate specific content, go to the Home tab, click Find & Select, then choose Find. You can also press Ctrl + F on your keyboard.
Enter the text you want to search for in the Find what field. Click Find Next to locate one instance at a time or Find All to display every match.
Advanced Search Options
Click Options to expand advanced search settings such as Match Case, Match Entire Cell Contents, and choosing whether to search within the current sheet or the entire workbook.
Using Replace
If you need to correct repeated mistakes or update values, use Replace. From the Home tab, click Find & Select, then choose Replace.
Enter the text to find in the Find what field and the replacement text in the Replace with field. Use Replace to update one instance at a time.
Using Replace All
Replace All updates every matching instance automatically. Use this option carefully, as it does not allow you to review changes individually.
Knowledge Check
Which keyboard shortcut opens the Replace dialog in Excel?
Practice File
Download this file and follow along with the lesson.
Challenge
Apply what you've learned in this lesson.
Complete the following tasks using the practice workbook:
- Change Crystal Lewis’s last name to Taylor using Find and Replace. Be careful to only change Crystal’s record.
- Replace Bio with Biology. Do NOT change Biomedical Engineering.
- Use Replace All to change Physics to Physical Science.
- Verify your worksheet matches the final expected result.
