Excel shortcuts

15 keyboard shortcuts for Excel search and find

If you work with Excel on a daily basis, then you know how important it is to be able to quickly find and replace data. The good news is that there are a number of keyboard shortcuts that can make your search and find tasks much easier and faster. In this article, we'll share 15 of the best keyboard shortcuts for Excel search and find.

1. Ctrl + F: This shortcut opens the Find and Replace dialog box, which allows you to search for a specific value in your worksheet and replace it with another value. You can also use this shortcut to find and replace formatting.

2. Ctrl + H: This shortcut also opens the Find and Replace dialog box, but with the search and replace values reversed. So, if you want to replace a value with another value, you would use this shortcut.

3. F3: This shortcut allows you to quickly find the next instance of a value that you're searching for. So, if you've already used the Ctrl + F shortcut to search for a specific value, you can use this shortcut to find the next instance of that value without having to re-enter your search criteria.

4. Shift + F3: This shortcut allows you to quickly find the previous instance of a value that you're searching for. So, if you've already used the Ctrl + F shortcut to search for a specific value, you can use this shortcut to find the previous instance of that value without having to re-enter your search criteria.

5. Ctrl + Shift + F: This shortcut opens the Format Cells dialog box, which allows you to search for and replace formatting in your worksheet. This is a great shortcut to use if you want to quickly change the font, color, or other formatting for a group of cells.

6. Ctrl + Shift + H: This shortcut also opens the Format Cells dialog box, but with the search and replace values reversed. So, if you want to replace formatting with other formatting, you would use this shortcut.

7. Ctrl + I: This shortcut opens the Go To dialog box, which allows you to search for a specific cell by its address. This is a great shortcut to use if you want to quickly jump to a specific cell in your worksheet.

8. F5: This shortcut opens the Go To dialog box, but with the option to search for a specific value instead of a cell address. This is a great shortcut to use if you want to quickly find a specific value in your worksheet.

9. Ctrl + G: This shortcut opens the Go To dialog box, but with the option to search for a specific object instead of a cell address. This is a great shortcut to use if you want to quickly find a specific object, such as a chart or image, in your worksheet.

10. Ctrl + F5: This shortcut opens the Find and Replace dialog box, but with the option to search for a specific value instead of a cell address. This is a great shortcut to use if you want to quickly find and replace a specific value in your worksheet.

11. Ctrl + Shift + F5: This shortcut opens the Find and Replace dialog box, but with the option to search for a specific object instead of a cell address. This is a great shortcut to use if you want to quickly find and replace a specific object, such as a chart or image, in your worksheet.

12. Ctrl + A: This shortcut selects all cells in your worksheet. This is a great shortcut to use if you want to quickly apply formatting or formulas to a large number of cells.

13. Ctrl + B: This shortcut applies bold formatting to the selected cells. This is a great shortcut to use if you want to quickly format a group of cells as bold.

14. Ctrl + U: This shortcut applies underline formatting to the selected cells. This is a great shortcut to use if you want to quickly format a group of cells as underlined.

15. Ctrl + 5: This shortcut applies strikethrough formatting to the selected cells. This is a great shortcut to use if you want to quickly format a group of cells as strikethrough.

These are just a few of the many keyboard shortcuts that can make your Excel search and find tasks easier and faster. For a complete list of keyboard shortcuts, check out the Excel help documentation or search for "keyboard shortcuts" on the Microsoft website.

Move beyond 

Excel

Get started with Causal today.
Build models effortlessly, connect them directly to your data, and share them with interactive dashboards and beautiful visuals.