Excel Find and Replace Shortcuts

Ctrl+F

Display the Find and Replace dialog box (with find selected)

Ctrl+H

Display the find and replace dialog box (with replace selected)

Esc

Close the find and replace dialog Box (with focus on dialog box)

Shift+F4

Find next (with search box closed)

Ctrl+Shift+F4

Find previous (with search box closed)

Alt+Tab, or Ctrl+F/H when losing focus

Toggle focus between find/ replace dialog box and worksheet

Alt+F

Find next with find dialog box active

Alt+I

Find all with find dialog box active

* in search option

Use as asterix for searching multiple characters

? in search options

Use as wildcard for searching any single character, Use '~' before '?' when searching special characters.
~* searches for *
~~ searches for ~
~? searches for ?

Created by max on 1/14/2021

 

0 Comments for '(Excel) - Excel Find and Replace Shortcuts'   

 
Email me replies   

Please kindly review and accept Terms of Use and Cookie & Policy Policy