Excel shortcuts

25 essential Microsoft Excel keyboard shortcuts

1. Ctrl + A: Select the entire worksheet. This shortcut will select all cells in the worksheet, even if there are blank cells or cells with data in them.

2. Ctrl + B: Bold the selected text. This shortcut will bold the selected text in the worksheet. If no text is selected, the shortcut will bold the cell that the cursor is currently in.

3. Ctrl + C: Copy the selected text or cell. This shortcut will copy the selected text or cell in the worksheet. If no text or cell is selected, the shortcut will copy the cell that the cursor is currently in.

4. Ctrl + D: Fill down. This shortcut will fill the selected cell down with the contents of the cell above it. This is useful for quickly filling in a series of cells with the same data.

5. Ctrl + F: Find. This shortcut will open the Find dialog box, where you can search for specific text in the worksheet.

6. Ctrl + G: Go to. This shortcut will open the Go To dialog box, where you can jump to a specific cell in the worksheet.

7. Ctrl + H: Replace. This shortcut will open the Replace dialog box, where you can search for and replace specific text in the worksheet.

8. Ctrl + I: Italicize the selected text. This shortcut will italicize the selected text in the worksheet. If no text is selected, the shortcut will italicize the cell that the cursor is currently in.

9. Ctrl + K: Insert hyperlink. This shortcut will insert a hyperlink in the selected cell. If no cell is selected, the shortcut will insert a hyperlink in the cell that the cursor is currently in.

10. Ctrl + N: Create a new workbook. This shortcut will create a new, blank workbook.

11. Ctrl + O: Open a workbook. This shortcut will open the Open dialog box, where you can select a workbook to open.

12. Ctrl + P: Print the active worksheet. This shortcut will open the Print dialog box, where you can select the printer and other options for printing the active worksheet.

13. Ctrl + S: Save the active workbook. This shortcut will save the active workbook.

14. Ctrl + U: Underline the selected text. This shortcut will underline the selected text in the worksheet. If no text is selected, the shortcut will underline the cell that the cursor is currently in.

15. Ctrl + V: Paste the contents of the clipboard. This shortcut will paste the contents of the clipboard into the selected cell. If no cell is selected, the shortcut will paste the contents of the clipboard into the cell that the cursor is currently in.

16. Ctrl + W: Close the active workbook. This shortcut will close the active workbook.

17. Ctrl + X: Cut the selected text or cell. This shortcut will cut the selected text or cell in the worksheet. If no text or cell is selected, the shortcut will cut the cell that the cursor is currently in.

18. Ctrl + Y: Repeat the last action. This shortcut will repeat the last action that was taken in the workbook. This is useful for quickly repeating a series of actions.

19. Ctrl + Z: Undo the last action. This shortcut will undo the last action that was taken in the workbook. This is useful for quickly undoing a mistake.

20. F2: Edit the selected cell. This shortcut will put the selected cell into edit mode, where you can change the contents of the cell.

21. F5: Open the Go To dialog box. This shortcut will open the Go To dialog box, where you can jump to a specific cell in the worksheet.

22. F7: Check spelling. This shortcut will open the Spelling dialog box, where you can check the spelling of the text in the workbook.

23. F11: Create a chart. This shortcut will create a chart from the data in the active worksheet.

24. Shift + F2: Insert a comment. This shortcut will insert a comment in the selected cell. If no cell is selected, the shortcut will insert a comment in the cell that the cursor is currently in.

25. Shift + F5: Open the Find dialog box. This shortcut will open the Find dialog box, where you can search for specific text in the worksheet.

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.