Excel shortcuts

25 Search on Excel Shortcuts You Need to Know

1. Ctrl + F: Find and Replace

This shortcut opens the Find and Replace dialog box, where you can search for and replace specific text or values in your workbook. You can also use this shortcut to find specific cells, sheets, or workbooks.

2. Ctrl + H: Go to

This shortcut opens the Go To dialog box, where you can search for and select specific cells, ranges, or sheets in your workbook. You can also use this shortcut to find and select specific workbooks.

3. Ctrl + G: Select

This shortcut opens the Select dialog box, where you can select specific cells, ranges, or sheets in your workbook. You can also use this shortcut to select specific workbooks.

4. F5: Refresh

This shortcut refreshes all the data in your workbook, including any changes that have been made to external data sources. This is a great shortcut to use if you're working with live data that is constantly changing.

5. F9: Calculate

This shortcut calculates all the formulas in your workbook. This is a great shortcut to use if you've made changes to your data that need to be reflected in your formulas.

6. F11: Create Chart

This shortcut creates a chart from the data in your workbook. This is a great shortcut to use if you want to quickly visualize your data.

7. Ctrl + S: Save

This shortcut saves your workbook. This is a great shortcut to use if you want to make sure your work is saved and backed up.

8. Ctrl + P: Print

This shortcut prints your workbook. This is a great shortcut to use if you want to share your work with others or create a hard copy for yourself.

9. Ctrl + Z: Undo

This shortcut undoes the last action you took. This is a great shortcut to use if you accidentally delete something or make a change you didn't mean to make.

10. Ctrl + Y: Redo

This shortcut redoes the last action you took. This is a great shortcut to use if you change your mind about an undo you made.

11. Ctrl + A: Select All

This shortcut selects all the data in your workbook. This is a great shortcut to use if you want to quickly select all the data in a large workbook.

12. Ctrl + C: Copy

This shortcut copies the selected data to the clipboard. This is a great shortcut to use if you want to quickly copy data from one place to another.

13. Ctrl + X: Cut

This shortcut cuts the selected data to the clipboard. This is a great shortcut to use if you want to quickly move data from one place to another.

14. Ctrl + V: Paste

This shortcut pastes the data on the clipboard into the selected cells. This is a great shortcut to use if you want to quickly paste data from one place to another.

15. Ctrl + B: Bold

This shortcut bolds the selected text. This is a great shortcut to use if you want to make your text stand out.

16. Ctrl + I: Italic

This shortcut italicizes the selected text. This is a great shortcut to use if you want to make your text stand out.

17. Ctrl + U: Underline

This shortcut underlines the selected text. This is a great shortcut to use if you want to make your text stand out.

18. Ctrl + 1: Format Cells

This shortcut opens the Format Cells dialog box, where you can format the selected cells. This is a great shortcut to use if you want to quickly format your cells.

19. Ctrl + 2: Font

This shortcut opens the Font dialog box, where you can format the selected text. This is a great shortcut to use if you want to quickly format your text.

20. Ctrl + 3: Fill

This shortcut opens the Fill dialog box, where you can fill the selected cells with color. This is a great shortcut to use if you want to quickly add color to your cells.

21. Ctrl + 4: Border

This shortcut opens the Border dialog box, where you can add borders to the selected cells. This is a great shortcut to use if you want to quickly add borders to your cells.

22. Ctrl + 5: Alignment

This shortcut opens the Alignment dialog box, where you can align the selected cells. This is a great shortcut to use if you want to quickly align your cells.

23. Ctrl + 6: Number

This shortcut opens the Number dialog box, where you can format the selected cells as numbers. This is a great shortcut to use if you want to quickly format your cells as numbers.

24. Ctrl + 7: Date

This shortcut opens the Date dialog box, where you can format the selected cells as dates. This is a great shortcut to use if you want to quickly format your cells as dates.

25. Ctrl + 8: Time

This shortcut opens the Time dialog box, where you can format the selected cells as times. This is a great shortcut to use if you want to quickly format your cells as times.

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.