← Back to Home
Keyboard Shortcuts Guide
Master productivity shortcuts for Excel and Windows
Navigation
| Shortcut |
Description |
| Ctrl + Home |
Go to cell A1 |
| Ctrl + End |
Go to last used cell |
| Ctrl + Arrow |
Jump to edge of data region |
| Ctrl + Page Up/Down |
Switch between worksheets |
| Alt + Page Up/Down |
Move one screen left/right |
Selection
| Shortcut |
Description |
| Ctrl + Shift + Arrow |
Select to edge of data region |
| Ctrl + A |
Select all cells (or current region) |
| Shift + Space |
Select entire row |
| Ctrl + Space |
Select entire column |
| Ctrl + Shift + End |
Select to last used cell |
Formatting
| Shortcut |
Description |
| Ctrl + B |
Bold |
| Ctrl + I |
Italic |
| Ctrl + U |
Underline |
| Ctrl + 1 |
Format Cells dialog |
| Ctrl + Shift + $ |
Apply currency format |
| Ctrl + Shift + % |
Apply percentage format |
| Ctrl + Shift + # |
Apply date format |
Editing
| Shortcut |
Description |
| F2 |
Edit active cell |
| Ctrl + D |
Fill down |
| Ctrl + R |
Fill right |
| Ctrl + ; |
Insert current date |
| Ctrl + Shift + : |
Insert current time |
| Alt + Enter |
New line in cell |
| Ctrl + K |
Insert hyperlink |
Formulas & Functions
| Shortcut |
Description |
| = |
Start formula |
| Alt + = |
AutoSum |
| Ctrl + ` |
Toggle formula display |
| F4 |
Toggle absolute/relative references |
| Ctrl + Shift + Enter |
Array formula |
| F9 |
Calculate all worksheets |
Data Management
| Shortcut |
Description |
| Ctrl + T |
Create table |
| Alt + A + S + S |
Sort & Filter |
| Ctrl + Shift + L |
Toggle filters |
| Alt + Down Arrow |
Open filter dropdown |
| Ctrl + - |
Delete rows/columns |
| Ctrl + + |
Insert rows/columns |
Window Management
| Shortcut |
Description |
| Win + Left/Right |
Snap window to left/right half |
| Win + Up |
Maximize window |
| Win + Down |
Minimize/restore window |
| Win + D |
Show/hide desktop |
| Win + M |
Minimize all windows |
| Alt + Tab |
Switch between open apps |
| Win + Tab |
Task view (timeline) |
| Alt + F4 |
Close active window |
System Functions
| Shortcut |
Description |
| Win + E |
Open File Explorer |
| Win + I |
Open Settings |
| Win + L |
Lock computer |
| Win + R |
Open Run dialog |
| Win + X |
Quick Link menu |
| Win + . |
Emoji panel |
| Win + V |
Clipboard history |
| Ctrl + Shift + Esc |
Task Manager |
Virtual Desktops
| Shortcut |
Description |
| Win + Ctrl + D |
Create new virtual desktop |
| Win + Ctrl + F4 |
Close current virtual desktop |
| Win + Ctrl + Left/Right |
Switch between virtual desktops |
Text Editing
| Shortcut |
Description |
| Ctrl + C |
Copy |
| Ctrl + X |
Cut |
| Ctrl + V |
Paste |
| Ctrl + Z |
Undo |
| Ctrl + Y |
Redo |
| Ctrl + A |
Select all |
| Ctrl + F |
Find |
| Ctrl + H |
Replace |
Screenshots
| Shortcut |
Description |
| Win + Shift + S |
Snipping Tool (Snip & Sketch) |
| Print Screen |
Screenshot to clipboard |
| Win + Print Screen |
Save screenshot to Pictures folder |
| Alt + Print Screen |
Screenshot active window |