Basic Shortcuts
Ctrl + N → New workbook
Ctrl + O → Open workbook
Ctrl + S → Save workbook
F12 → Save As
Ctrl + P → Print
Ctrl + Z → Undo
Ctrl + Y → Redo
Ctrl + X → Cut
Ctrl + C → Copy
Ctrl + V → Paste
Ctrl + A → Select all
Ctrl + F → Find
Ctrl + H → Replace
Ctrl + G / F5 → Go to
Navigation Shortcuts
Arrow Keys → Move cell selection
Ctrl + Arrow Key → Jump to edge of data
Ctrl + Home → Go to A1
Ctrl + End → Go to last used cell
Page Up / Page Down → Move up/down a screen
Alt + Tab → Switch between applications
Editing Shortcuts
F2 → Edit active cell
Ctrl + Enter → Fill selected cells with the same entry
Ctrl + D → Fill down
Ctrl + R → Fill right
Alt + Enter → Start a new line in the same cell
Ctrl + ‘ → Copy formula from above
Ctrl + Shift + “ → Copy value from above
Formatting Shortcuts
Ctrl + B → Bold
Ctrl + I → Italic
Ctrl + U → Underline
Ctrl + 1 → Format Cells dialog
Ctrl + Shift + $ → Currency format
Ctrl + Shift + % → Percentage format
Ctrl + Shift + # → Date format
Ctrl + Shift + @ → Time format
Ctrl + Shift + ! → Comma format
Row & Column Shortcuts
Ctrl + Space → Select entire column
Shift + Space → Select entire row
Ctrl + Shift + + → Insert row/column
Ctrl + - → Delete row/column
Alt + H + O + I → AutoFit column width
Formula Shortcuts
= → Start a formula
Alt + = → AutoSum
F9 → Calculate worksheet
Shift + F3 → Insert function
Ctrl + ` → Show formulas
Data & Pivot Table Shortcuts
Ctrl + T → Create table
Alt + D + P → Open PivotTable wizard
Ctrl + Shift + L → Toggle filters
Other Useful Shortcuts
Alt + E + S + V → Paste values
Ctrl + Alt + V → Open Paste Special
Alt + H + D + C → Delete column
Alt + H + D + R → Delete row
Post a Comment
0Comments