The replace shortcut key is Ctrl + H. In Word, Excel, PowerPoint and Notepad it opens the Find and Replace box with the Replace tab ready: type the word to find, type its replacement, and press Replace All.
Find on its own is Ctrl + F. Together they are the quickest way to fix a misspelt name across a 30 page report or change a code in hundreds of Excel cells.
Quick facts
Find and replace
Ctrl + HFind only
Ctrl + FReplace all
Alt + A in the boxNext match
Alt + FUndo replace all
Ctrl + ZWord for Mac
Control + H
Find and replace shortcut key by program
| Program | Replace keys | Find keys |
|---|---|---|
| Word | Ctrl + H | Ctrl + F (side pane) |
| Excel | Ctrl + H | Ctrl + F |
| PowerPoint | Ctrl + H | Ctrl + F |
| Notepad | Ctrl + H | Ctrl + F |
| Browsers | No replace on web pages | Ctrl + F |
| Word for Mac | Control + H | Command + F |
How to use the replace shortcut in Word
- Press Ctrl + H. The cursor is in the Find what box.
- Type the word to change, press Tab, and type the new word in Replace with.
- Press Alt + F to see the next match, or Alt + R to replace just that one.
- Press Alt + A to replace every match. Word tells you how many were changed.
If Replace All changed too much, one press of Ctrl + Z undoes the whole batch. It is a good habit to press Find Next a couple of times first, to see what kind of text will be changed, before replacing everything in a long contract or report.
Match case and whole words
Click More in the Word box to see options. Wildcards and special characters such as paragraph marks are also there, for advanced clean up of documents pasted from email. Match case stops Ram from also changing ram, and Find whole words only stops cat from changing inside category. These two ticks prevent most find and replace mistakes.
Replace in Excel
In Excel, Ctrl + H searches the selected cells or, with one cell selected, the whole sheet. Choose Within: Workbook under Options to change every sheet at once. Look in: Formulas lets you change part of a formula, such as a sheet name, everywhere it appears. Excel also has a Replace format option, so you can turn every cell with a red fill into green in one go. Our Excel shortcut keys list has the related keys.
When the replace shortcut does not work
| Problem | Fix |
|---|---|
| Ctrl + H opens history | You are in a browser; web pages have find only |
| No matches found | Check spaces and Match case; clear old formatting in the box |
| Replaced inside other words | Tick Find whole words only |
| Excel says cannot find data | Select one cell so the whole sheet is searched |
Frequently asked questions
What is the shortcut key for replace?
What is the find and replace shortcut key in Word?
How do I replace all at once?
In the Replace box, press Alt + A or click Replace All.
Can I undo replace all?
Yes, press Ctrl + Z once.
Does Ctrl + H work in Excel?
Yes, it opens Find and Replace with the Replace tab.