/en/excel/working-with-multiple-worksheets/content/
When working with a lot of data in Excel, it can be difficult and time consuming to locate specific information. You can easily search your workbook using the Find feature, which also allows you to modify content using the Replace feature.
Optional: Download our practice workbook.
Watch the video below to learn more about using Find and Replace.
In our example, we'll use the Find command to locate a specific department in this list.
You can also access the Find command by pressing Ctrl+F on your keyboard.
Click Options to see advanced search criteria in the Find and Replace dialog box.
At times, you may discover that you've repeatedly made a mistake throughout your workbook (like misspelling someone's name) or that you need to exchange a particular word or phrase for another. You can use Excel's Find and Replace feature to make quick revisions. In our example, we'll use Find and Replace to correct a list of department names.
A dialog box will appear, confirming the number of replacements made. Click OK to continue.
The selected cell content will be replaced.
Generally, it's best to avoid using Replace All because it doesn't give you the option of skipping anything you don't want to change. You should only use this option if you're absolutely sure it won't replace anything you didn't intend it to.
/en/excel/checking-spelling/content/
About cookies on this site
Sharing your cookies helps us improve the site, optimize your experience, and understand the extent of our impact. By closing this banner, you agree to the use of cookies on this website (This option applies to users outside the United States and Europe). Learn more about how we use cookies by clicking on Cookie Settings.