Excel shortcuts

Search Shortcuts in Excel: The Complete Guide

If you work with data in Excel, you know how important it is to be able to find what you're looking for quickly and easily. That's why we've put together this complete guide to search shortcuts in Excel.

Whether you're looking for a specific value, or trying to find all the cells that contain a certain type of data, these search shortcuts will help you get the job done faster.

To use any of these shortcuts, simply press the Ctrl key on your keyboard and the appropriate letter or number listed below.

1. Ctrl+F: Find a Specific Value

If you know the value you're looking for, this shortcut is the quickest way to find it. Simply press Ctrl+F to open the Find and Replace dialog box, then enter the value you're looking for in the Find what field.

You can also use this shortcut to find a specific format, such as a specific number format or font color. To do this, open the Find and Replace dialog box (Ctrl+F), then click the Options button. This will open a new dialog box with additional search options, including the ability to search by format.

2. Ctrl+H: Find and Replace

This shortcut is similar to the previous one, but instead of simply finding a value, it allows you to find and replace values. To use this shortcut, press Ctrl+H to open the Find and Replace dialog box. Then, enter the value you want to find in the Find what field, and the value you want to replace it with in the Replace with field.

As with the Ctrl+F shortcut, you can also use this shortcut to find and replace specific formats. To do this, open the Find and Replace dialog box (Ctrl+H), then click the Options button. This will open a new dialog box with additional search options, including the ability to search by format.

3. Ctrl+G: Go to a Specific Cell

If you know the address of the cell you want to go to, this shortcut is the quickest way to get there. Simply press Ctrl+G to open the Go To dialog box, then enter the address of the cell you want to go to in the Reference field.

You can also use this shortcut to go to a specific sheet in a workbook. To do this, open the Go To dialog box (Ctrl+G), then click the Special button. This will open a new dialog box with a number of options for special types of cells you can go to, including sheets. Select the type of cell you want to go to, then click OK.

4. F5: Go to a Specific Cell or Range

This shortcut is similar to the previous one, but instead of going to a specific cell, it allows you to go to a specific cell or range of cells. To use this shortcut, press F5 to open the Go To dialog box. Then, enter the address of the cell or range you want to go to in the Reference field.

You can also use this shortcut to go to a specific named range. To do this, open the Go To dialog box (F5), then click the Named Range button. This will open a new dialog box with a list of all the named ranges in the workbook. Select the named range you want to go to, then click OK.

5. Ctrl+O: Open a Workbook

This shortcut allows you to quickly open an existing workbook. Simply press Ctrl+O to open the Open dialog box, then navigate to the location of the workbook you want to open and click Open.

6. Ctrl+S: Save a Workbook

This shortcut allows you to quickly save a workbook. Simply press Ctrl+S to open the Save As dialog box, then enter a name for the workbook and click Save.

7. Ctrl+P: Print a Workbook

This shortcut allows you to quickly print a workbook. Simply press Ctrl+P to open the Print dialog box, then select the printer and click Print.

8. Ctrl+Z: Undo an Action

This shortcut allows you to undo the last action you took. Simply press Ctrl+Z and the action will be undone.

9. Ctrl+Y: Redo an Action

This shortcut allows you to redo the last action you took. Simply press Ctrl+Y and the action will be redone.

10. Ctrl+A: Select All

This shortcut allows you to quickly select all the cells in a worksheet. Simply press Ctrl+A and all the cells will be selected.

11. Ctrl+B: Bold

This shortcut allows you to quickly bold the selected cells. Simply press Ctrl+B and the cells will be bolded.

12. Ctrl+I: Italic

This shortcut allows you to quickly italicize the selected cells. Simply press Ctrl+I and the cells will be italicized.

13. Ctrl+U: Underline

This shortcut allows you to quickly underline the selected cells. Simply press Ctrl+U and the cells will be underlined.

14. Ctrl+1: Format Cells

This shortcut allows you to quickly format the selected cells. Simply press Ctrl+1 to open the Format Cells dialog box, then make the desired changes and click OK.

15. Ctrl+7: Comment

This shortcut allows you to quickly add a comment to the selected cell. Simply press Ctrl+7 to open the Comment dialog box, then enter the comment and click OK.

16. Ctrl+9: Hide Rows

This shortcut allows you to quickly hide the selected rows. Simply press Ctrl+9 and the rows will be hidden.

17. Ctrl+0: Hide Columns

This shortcut allows you to quickly hide the selected columns. Simply press Ctrl+0 and the columns will be hidden.

18. Ctrl++: Insert Rows

This shortcut allows you to quickly insert rows above the selected cells. Simply

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.