Excel Shortcuts

Excel shortcuts can help you to dominate the app and work faster and more efficiently.

File Operations:

Ctrl + N: Create a new workbook.
Ctrl + O: Open an existing workbook.
Ctrl + S: Save the current workbook.
Ctrl + P: Open the Print dialog box.
Ctrl + W: Close the current workbook.

Editing:

Ctrl + C: Copy selected cells.
Ctrl + X: Cut selected cells.
Ctrl + V: Paste copied or cut cells.
Ctrl + Z: Undo the last action.
Ctrl + Y: Redo the last undone action.
Delete: Clear the content of selected cells.

Formatting:

Ctrl + B: Apply or remove bold formatting.
Ctrl + I: Apply or remove italic formatting.
Ctrl + U: Apply or remove underline formatting.
Ctrl + 1: Open the Format Cells dialog box.
Alt + H, H: Choose a fill color.

Navigation:

Arrow Keys: Move one cell up, down, left, or right.
Ctrl + Arrow Keys: Move to the edge of data regions.
Tab: Move one cell to the right.
Shift + Tab: Move one cell to the left.
Ctrl + Home: Go to the beginning of the worksheet.
Ctrl + End: Go to the last used cell in the worksheet.
Page Up/Page Down: Move one screen up or down.
Alt + Page Up/Page Down: Move one screen to the left or right.

Selection:

Shift + Arrow Keys: Extend the selection by one cell.
Ctrl + Shift + Arrow Keys: Extend the selection to the last non-blank cell in the same column or row.
Ctrl + A: Select the entire worksheet.

Formulas:

Alt + =: Insert the SUM function.
Ctrl + `: Toggle between displaying cell values and formulas.

Miscellaneous:

Ctrl + F: Open the Find dialog box.
Ctrl + H: Open the Replace dialog box.
Ctrl + K: Insert a hyperlink.
F7: Open the Spelling dialog box.
Shift + F3: Open the Insert Function dialog box.