200+ Excel Keyboard Shortcuts - 10x Your Productivity

Overview

• Learning Excel shortcuts can greatly enhance productivity.
• Not necessary to learn all shortcuts, but focus on those frequently used.
• The document provides a list of shortcuts categorized by their function.

Categories of Excel Shortcuts

Workbook Related Shortcuts

• Create new workbook: Ctrl + N
• Open file: Ctrl + O
• Save workbook: Ctrl + S
• Save as dialog: F12
• Print preview: Ctrl + F2
• Close workbook: ALT + F4

Excel Cell Editing Shortcuts

• Edit active cell: F2
• New line in same cell: ALT + ENTER
• Delete character left: Backspace

Navigation Shortcuts

• Move one cell up: (Arrow key)
• Move one cell down: (Arrow key)
• Move one screen down: PageDown

General Excel Shortcuts

• Open help: F1
• Undo: Ctrl + Z
• Spell check: F7
• Print menu: Ctrl + P

Cut, Copy, and Paste

• Copy: Ctrl + C
• Cut: Ctrl + X
• Paste: Ctrl + V

Data Entry Shortcuts

• Enter and move down: Enter
• Fill down: Ctrl + D
• Insert current date: Ctrl + ;

Clear Shortcuts

• Clear everything: Alt + H + E + A
• Clear formats: Alt + H + E + F

Selection Shortcuts

• Select all: Ctrl + A
• Select entire row: Shift + Space

Alignment Shortcuts

• Align center: Alt + H + A + C
• Align left: Alt + H + A + L

Hide/Unhide Shortcuts

• Hide rows: Ctrl + 9
• Unhide columns: Ctrl + Shift + 0

Insert Shortcuts

• Insert new worksheet: Shift + F11
• Insert row/cell: Ctrl + Shift + =

Formatting Shortcuts

• Bold: Ctrl + B
• Italic: Ctrl + I
• Underline: Ctrl + U
• Currency format: Ctrl + Shift + $

Excel Formula-Related Shortcuts

• Autosum: Alt + =
• Toggle value/formula display: Ctrl + `

Find and Replace Shortcuts

• Find: Ctrl + F
• Replace: Ctrl + H

Conditional Formatting Shortcuts

• Open dialog box: Alt O D
• Clear conditions: Alt H L C E

Charting Shortcuts

• Insert chart: Alt + F1

VBA Shortcuts

• Open VBA editor: Alt + F11
• Run macro: F5

Additional Resources

• Links to additional Excel resources such as interview questions, free templates, and advanced functions.

These shortcuts are designed to streamline and optimize Excel workflow, making frequent tasks more accessible and efficient.