Category: Find and replace

If you want to find and select all the cells in an Excel worksheet that contain a comment, you can go to Home > Find & Select > Comments, or you can use this shortcut:

Ctrl+Shift+O

FULL POST

If you want to repeat your last Find command in Excel, ie. go to the cell that contains the value that you searched for the last time you used Find and Replace, you can use this shortcut:

Shift+F4

FULL POST

If you want to open the Find and Replace dialog box in Excel, with the Replace tab already selected, you can go to Home > Find and Select > Replace, or you can use this shortcut:

Ctrl+H

FULL POST

If you want to open the Find and Replace dialog box in Excel, you can go to Home > Find and Select > Find, or you can use one of these shortcuts:

Ctrl+F
Shift+F5

FULL POST