If you are looking for MS Excel Shortcut Keys with Description PDF, then you are in the right place. At the end of this post, we have added a button to directly download the PDF of 239 MS Excel Shortcut Keys for free.
MS Excel Shortcut Key
Here we have shared the most used Excel Shortcut Keys and Formulas.
| Excel Shortcuts Keys for Windows | Excel Shortcuts Keys for Mac | Excel Shortcut Function |
|---|---|---|
| Ctrl+A | ⌘+A | Select all contents of a worksheet. |
| Ctrl+B | ⌘+B | Bold all cells in the highlighted section. |
| Ctrl+D | ⌘+D | Fill in the Content of the selected cell from top to bottom. CTRL + D (i.e. Ctrl+ Down) |
| Ctrl+F | ⌘+F | “Search the current sheet. |
| Ctrl+G | ⌘+G | Go to a certain area. |
| Ctrl+H | ⌘+H | Find and replace. |
| Ctrl+I | ⌘+I | Puts italics on all cells in the highlighted section. |
| Ctrl+K | ⌘+K | Inserts a hyperlink. |
| Ctrl+P | ⌘+P | Print the current sheet. |
| Ctrl+R | ⌘+R | Fill Right. |
| Ctrl+S | ⌘+S | Saves the open worksheet. |
| Ctrl+U | ⌘+U | Underlines all cells in the highlighted section. |
| Ctrl+V | ⌘+V | Pastes everything copied onto the clipboard. |
| Ctrl+W | ⌘+W | Closes the current workbook. |
| Ctrl+X | ⌘+X | Cuts all cells within the highlighted section. |
| Ctrl+Y | ⌘+Y | Repeats the last entry. |
| Ctrl+Z | ⌘+Z | Undo the last action. |
| Ctrl+1 | ⌘+1 | Changes the format of the selected cells. |
| Ctrl+2 | ⌘+2 | Bolds all cells in the highlighted section. |
| Ctrl+3 | ⌘+3 | Puts italics all cells in the highlighted section. |
| Ctrl+4 | ⌘+4 | Underlines all cells in the highlighted section. |
| Ctrl+5 | ⌘+5 | Puts a strikethrough all cells in the highlighted section. |
| Ctrl+6 | ⌘+6 | Shows or hides objects. |
| Ctrl+7 | ⌘+7 | Shows or hides the toolbar. |
| Ctrl+8 | ⌘+8 | Toggles the outline symbols. |
| Ctrl+9 | ⌘+9 | Hides rows. |
| Ctrl+0 | ⌘+0 | Hides columns. |
| Ctrl+Shift+: | ⌘+⇧+: | Enters the current time. |
| Ctrl+; | ⌘+; | Enters the current date. |
| Ctrl+` | ⌘+` | Changes between displaying cell values or formulas in the worksheet. |
| Ctrl+‘ | ⌘+‘ | Copies a formula from the cell above. |
| Ctrl+Shift+“ | ⌘+⇧+“ | Copies value from the cell above. |
| Ctrl+– | ⌘+– | Deletes the selected column or row. |
| Ctrl+Shift+= | ⌘+⇧+= | Inserts a new column or row. |
| Ctrl+Shift+~ | ⌘+⇧+~ | Switches between showing Excel formulas or their values in cells. |
| Ctrl+Shift+@ | ⌘+⇧+@ | Applies time formatting. |
| Ctrl+Shift+! | ⌘+⇧+! | Applies comma formatting. |
| Ctrl+Shift+$ | ⌘+⇧+$ | Applies currency formatting. |
| Ctrl+Shift+# | ⌘+⇧+# | Applies date formatting. |
| Ctrl+Shift+% | ⌘+⇧+% | Applies percentage formatting. |
| Ctrl+Shift+^ | ⌘+⇧+^ | Applies exponential formatting. |
| Ctrl+Shift+* | ⌘+⇧+* | Selects the current region around the active cell. |
| Ctrl+Shift+& | ⌘+⇧+& | Places border around selected cells. |
| Ctrl+Shift+_ | ⌘+⇧+_ | Removes a border. |
| Ctrl++ | ⌘++ | Insert. |
| Ctrl+– | ⌘+– | Delete. |
| Ctrl+Shift+( | ⌘+⇧+( | Unhide rows. |
| Ctrl+Shift+) | ⌘+⇧+) | Unhide columns. |
| Ctrl+/ | ⌘+⇧+) | Selects the array containing the active cell. |
| Ctrl+\ | ⌘+\ | Selects the cells that have a static value or don’t match the formula in the active cell. |
| Ctrl+[ | ⌘+\ | Selects all cells referenced by formulas in the highlighted section. |
| Ctrl+] | ⌘+] | Selects cells that contain formulas that reference the active cell. |
| Ctrl+Shift+{ | ⌘+⇧+{ | Selects all cells directly or indirectly referenced by formulas in the highlighted section. |
| Ctrl+Shift+} | ⌘+⇧+} | Selects cells that contain formulas that directly or indirectly reference the active cell. |
| Ctrl+Shift+| | ⌘+⇧+| | Selects the cells within a column that don’t match the formula or static value in the active cell. |
| Ctrl+Enter | ⌘+Return | Fills the selected cells with the current entry. |
| Ctrl+Spacebar | ⌘+Spacebar | Selects the entire column. |
| Ctrl+Shift+Spacebar | ⌘+⇧+Spacebar | Selects the entire worksheet. |
| Ctrl+Home | Fn+⌃+← | Move to cell A1. |
| Ctrl+End | Fn+⌃+→ | Move to the last cell on a worksheet. |
| Ctrl+Tab | ⌘+Tab | Move between Two or more open Excel files. |
| Ctrl+Shift+Tab | ⌘+⇧+Tab | Activates the previous workbook. |
| Ctrl+Shift+A | ⌘+⇧+A | Inserts argument names into a formula. |
| Ctrl+Shift+F | ⌘+⇧+F | Opens the drop-down menu for fonts. |
| Ctrl+Shift+F | ⌘+⇧+F | Selects all of the cells that contain comments. |
| Ctrl+Shift+P | ⌘+⇧+P | Opens the drop-down menu for the point size. |
| Shift+Insert | ⇧+Insert | Pastes what is stored on the clipboard. |
| Shift+pg up | Fn+⇧+↑ | In a single column, highlights all cells above that which are selected. |
| Shift+pg dn | Fn+⇧+↓ | In a single column, highlights all cells above that which are selected. |
| Shift+Home | Fn+⇧+← | Highlights all text to the left of the cursor. |
| Shift+End | Fn+⇧+→ | Highlights all text to the right of the cursor. |
| Shift+↑ | ⇧+↑ | Extends the highlighted area up to one cell. |
| Shift+↓ | ⇧+↓ | Extends the highlighted area down one cell. |
| Shift+← | ⇧+← | Extends the highlighted area left one character. |
If you want to download Excel Shortcut Keys for Windows and Mac PDF, then click on the download button provided at the end of this post.
Checkout:
- Index Number in Statistics Notes PDF
- Mixed Tenses Exercise with Answers PDF
- Bank of Baroda Cash/Cheque Deposit Slip PDF
Download MS Excel Shortcut Key PDF
To download MS Excel Shortcuts and Formulas PDF, then click on the below download button. Within a few seconds, Advance MS Excel Shortcut Keys will be on your device.