Find and Replace in Excel
Find and Replace in Excel allows you to quickly search for specific text, numbers, or values and replace them with new content across cells, worksheets, or entire workbooks.
Keyboard Shortcut
| Windows | Mac |
|---|---|
| Ctrl + H | Cmd + Shift + H |
What Does Find and Replace Do?
This shortcut opens the Replace tab of the Find and Replace dialog box, allowing you to replace one value with another instantly.
How to Use Find and Replace
- Press Ctrl + H (Windows)
- Enter the text or value to find
- Enter the replacement value
- Click Replace or Replace All
Common Use Cases
- Fix spelling mistakes across worksheets
- Replace outdated values or codes
- Update formulas or references
- Remove unwanted characters
Tips & Best Practices
- Use Find Next before Replace All
- Enable Match case for precise replacements
- You can limit replacement to selected cells only
FAQ
- Q: Can Find and Replace work on formulas?
- Yes, you can replace text inside formulas.
- Q: Is Replace All reversible?
- You can undo it immediately using Ctrl + Z.