Hey Everyone, Today is something for MS office user. As you know Excel is one of best program for creating awesome spreadsheets, collecting and analyzing data in a manner.
If you are creating spreadsheet, data tables, charts without knowing the Shortcut Keys of it, then Dude, You are wasting 20% of your time. Today in this article, you are gonna learn about MS Excel Keys which can you help in speeding up your spreadsheet, data analysis work.
I will be telling you which key does what? MS Excel Shortcut Keys along their functions.
Table of Contents
MS Excel Shortcut Keys for Beginners
Before getting start, lets know windows and Mac may have different keys from each other. But no problem, I will be mentioning keys for both.
Working with files : MS Excel Keyboard Shortcuts
Why are using hovering your mouse all the time on screen while you can do half of work using the keys to work with files in MS Excel such as opening a file, saving, printing, closing Excel etc. Check out the keys below
| Windows Keys | Mac Keys | Functions |
|---|---|---|
| Ctrl + N | ⌘ + N | New File |
| Ctrl + O | ⌘ + O | Open File |
| Ctrl + S | ⌘ + S | Save |
| Ctrl + Shift + S | ⌘ + Shift + S | Save as |
| Ctrl + P | ⌘ + P | |
| Ctrl + F2 | ⌘ + P | Print Preview |
| Ctrl + W | ⌘ + W | Close Workbook |
| Ctrl + Q | ⌘ + Q | Close Excel |
Working with Data : Excel Shortcut Formulas
With these Shortcut Formulas you can speed up the work like copy, pasting, Undo, Redo, Find, etc. Check out these MS Excel shortcut for Mac and Windows.
| Windows Keys | Mac Keys | Functions |
|---|---|---|
| Ctrl + C | ⌘ + C | Copy |
| Ctrl + X | ⌘ + X | Cut |
| Ctrl + V | ⌘ + V | Paste |
| Ctrl + Alt + V | Control + ⌘ + V | Paste special |
| Ctrl + Z | ⌘ + Z | Undo |
| Ctrl + Y | ⌘ + Y | Redo |
| Ctrl + F | ⌘ + F | Find |
| Ctrl + Shift + F4 | ⌘ + Shift + G | Find previous |
| Ctrl + F4 | ⌘ + G | Find next |
| Ctrl + H | Control + H | Find and replace |
Moving within workbook
Here using these formula, you will be able to move within workbook like moving righ, left, up, down etc.
| Windows Keys | Mac Keys | Functions |
|---|---|---|
| → | → | Move right |
| ← | ← | Move left |
| ↑ | ↑ | Move up |
| ↓ | ↓ | Move down |
| Ctrl + → | Control + → | Move right to next full cell |
| Ctrl + ← | Control + ← | Move left to next full cell |
| Ctrl + ↑ | Control + ↑ | Move up to next full cell |
| Ctrl + ↓ | Control + ↓ | Move down to next full cell |
| Home | Fn + ← | Move to beginning of row |
| Ctrl + End | Fn + Control + → | Move to last cell |
| Ctrl + Home | Fn + Control + ← | Move to first cell |
| Alt + PgDn | Fn + Option + ↑ | Scroll right one screen |
| Alt + PgUp | Fn + Option + ↓ | Scroll left one screen |
| PgUp | Fn + ↑ | Scroll up one screen |
| PgDn | Fn + ↓ | Scroll down one screen |
| End | Fn + → | End mode |
Selecting Cells : MS Excel Shortcut Keys pc
| Windows Keys | Mac Keys | Functions |
|---|---|---|
| Ctrl + G | Control + G | Go to cell |
| Ctrl + A | ⌘ + A | Select all |
| Shift + Space | Shift + Space | Select row |
| Ctrl + Space | Control + Space | Select column |
| Ctrl + Shift + * | Shift + Control + Space | Select current region |
| Ctrl + / | Control + / | Select current array |
| Ctrl + Shift + { | Control + Shift + { | Select all precedents |
| Ctrl + ] | Control + ] | Select direct dependents |
| Ctrl + Shift + } | Control + Shift + } | Select all dependents |
| Alt + ; | ⌘ + Shift + Z | Select only visible cells |
| Shift + Click | Shift + Click | Add cell range to selection |
| Ctrl + Click | ⌘ + Click | Add one-off cells to selection |
| Ctrl + Alt + → | Control + Option + → | Move active cell right to non-adjacent selection |
| Ctrl + Alt + ← | Control + Option + ← | Move active cell left to non-adjacent selection |
| Option + Tab | Move selection one column left | |
| Option + Shift + Tab | Move selection one column right | |
| Shift + F8 | Fn + Shift + F8 | Toggle selection add mode |
| Esc | Esc | Clear selection |
| Shift + → | Shift + → | Expand selection to the right |
| Shift + ← | Shift + ← | Expand selection to the left |
| Shift + ↑ | Shift + ↑ | Expand selection up |
| Shift + ↓ | Shift + ↓ | Expand selection down |
| Ctrl + Shift + → | ⌘ + Shift + → | Expand selection to last full cell to the right |
| Ctrl + Shift + ← | ⌘ + Shift + ← | Expand selection to last full cell to the left |
| Ctrl + Shift + ↑ | ⌘ + Shift + ↑ | Expand selection to last full cell up |
| Ctrl + Shift + ↓ | ⌘ + Shift + ↓ | Expand selection to last full cell down |
| Shift + PgUp | Fn + Shift + ↑ | Expand selection up full screen |
| Shift + PgDn | Fn + Shift + ↓ | Expand selection down full screen |
| Shift + Home | Fn + Shift + ← | Expand selection to beginning of row |
| Ctrl + Shift + Home | Fn + Control + Shift + ← | Expand selection to first worksheet cell |
| Ctrl + Shift + End | Fn + Control + Shift + → | Expand selection to last worksheet cell |
| F8 | Fn + F8 | Toggle extend selection mode |
| Ctrl + Shift + O | Fn + Control + Shift + O | Select only cells with comments |
| Ctrl + \ | Control + \ | Select row differences |
| Ctrl + Shift + | | Control + Shift + | | Select column differences |
| Ctrl + [ | Control + [ | Select direct precedents |
More advanced excel shortcut formulas will be added soon so please bookmark this page and keep checking it for more Keys.