The following keyboard shortcuts can be used to navigate an Excel worksheet.
Action | Mac Shortcut | Windows Shortcut |
---|---|---|
Cut | ⌘ + X | Ctrl + X |
Copy | ⌘ + C | Ctrl + C |
Paste | ⌘ + V | Ctrl + V |
Undo | ⌘ + Z | Ctrl + Z |
Redo | ⌘ + Y | Ctrl + Y |
Save | ⌘ + S | Ctrl + S |
Open | ⌘ + O | Ctrl + O |
Close | ⌘ + W | Ctrl + W |
Select All | ⌘ + A | Ctrl + A |
Bold | ⌘ + B | Ctrl + B |
Italic | ⌘ + I | Ctrl + I |
Underline | ⌘ + U | Ctrl + U |
Find | ⌘ + F | Ctrl + F |
Replace | ⌘ + H | Ctrl + H |
New Workbook | ⌘ + N | Ctrl + N |
Close Workbook | ⌘ + W | Ctrl + W |
⌘ + P | Ctrl + P | |
Insert or Edit Comment | ⌘ + Option + M | Shift + F2 |
Fill Down | ⌘ + D | Ctrl + D |
Fill Right | ⌘ + R | Ctrl + R |
Go to Cell A1 | ⌘ + Home | Ctrl + Home |
Go to Last Cell in Data Region | ⌘ + ↓ (Down Arrow) | Ctrl + ↓ (Down Arrow) |
Go to First Cell in Data Region | ⌘ + ↑ ( Up Arrow) | Ctrl + ↑ (Up Arrow) |
Cut Row/Column | ⌘ + - (Minus) | Ctrl + - (Minus) |
Insert Row/Column | ⌘ + Shift + + | Ctrl + Shift + + |
AutoSum Selected Cells | ⌘ + Shift + T | Alt + = |
Format Cells Dialog | ⌘ + 1 | Ctrl + 1 |
Insert Chart | ⌘ + F11 | F11 |
Apply Number Format (Currency) | ⌘ + Shift + $ | Ctrl + Shift + $ |