Learn › Excel › Find and replace
Excel find and replace shortcut: Ctrl + H
Change a word to another word in the whole sheet, in one go.
With voice. Recorded in Excel for the web; the shortcut works the same in desktop Excel. Recorded on a US keyboard. On other keyboards some keys differ: see the table below the video.
Keys on keyboards of other languages
The video is recorded on an English (US) keyboard. This is how the same shortcut is pressed on the keyboards of the other languages. The highlighted row is your language.
What it does
Ctrl + H opens the Find and Replace window on the Replace tab. Type what to find and what to put instead, and press Replace all to change every match at once. Ctrl + F opens the same window on the Find tab, to search without changing anything.
When to use it
Use it to fix a name spelled wrongly in many rows, change a product name or remove a word. Check how many matches there are before you press Replace all, because afterwards you can only undo it with Ctrl + Z.
How to do it
- Click a cell in your sheet, or select the range you want to change.
- Press Ctrl + H, type the old word in Find and the new word in Replace with.
- Press Replace all. Excel tells you how many matches were replaced.
A quick example
Your orders table has three items called Notebook, and you want them to say Planner. Press Ctrl + H, type Notebook in Find and Planner in Replace with, and press Replace all. The window shows Matches replaced (3), and all three cells change.
Find, Replace and the search options
Ctrl + F only searches and jumps from match to match, while Ctrl + H also changes the text. The search options in the window let you match the whole cell or the exact capital letters. Wildcards help with patterns: a question mark stands for one character and an asterisk for any number of characters.
Shortcuts mentioned on this page, with video:
Not working? Check this
- Nothing happens: click into the sheet first. If your browser opens its history instead, click into the sheet before you press the keys, or use Home, Find & Select, Replace.
- Too many cells changed: Replace works on the whole sheet unless you selected a range first. Press Ctrl + Z and select the range before you replace.
- It replaces part of a word: turn on Match entire cell contents under Search options.
- On a Mac the shortcut is Control + H.
- The letter keys are the English ones. In some language versions of Excel the letters differ. If the keys do nothing in yours, use the matching button on the ribbon instead.
Quick answers
What is the shortcut for find and replace in Excel?
Press Ctrl + H. Ctrl + F opens the same window on the Find tab. On a Mac use Control + H.
How do I replace only some cells?
Select the cells first, then press Ctrl + H. Excel changes matches only inside the selection. Use Replace instead of Replace all to check each one.
Can I undo Replace all?
Yes. Press Ctrl + Z right away. If you saved and closed the file, undo is gone, so keep a copy before big changes.

