Key Combination | Action |
---|---|
Ctrl + 0 | Hide Columns |
Ctrl + 1 | Display Format Cells dialog |
Ctrl + 5 | Apply or Remove Strikethrough formatting |
Ctrl + 6 | Hide and Show Objects |
Ctrl + 8 | Show or hide outline symbols |
Ctrl + 9 | Hide Rows |
Ctrl + A | Select All |
Ctrl + B | Apply or Remove Bold formatting |
Ctrl + C | Copy selected cells |
Ctrl + D | Fill down from the top cell in the selection |
Ctrl + D | Duplicate Object (with objects) |
Ctrl + E | Flash Fill |
Ctrl + F | Find and Replace |
Ctrl + G | Display Go To dialog |
Ctrl + H | Replace |
Ctrl + I | Apply or Remove Italic formatting |
Ctrl + K | Add Hyperlink |
Ctrl + L | Create Table |
Ctrl + N | Create a New workbook |
Ctrl + O | Open an existing workbook |
Ctrl + P | Print file |
Ctrl + Q | Quick Analysis Tool |
Ctrl + R | Fill right from the cell on leftmost cell in the selection |
Ctrl + S | Save workbook |
Ctrl + T | Create an Excel Table |
Ctrl + U | Apply or Remove Undeline formatting |
Ctrl + V | Paste content from clipboard |
Ctrl + W | Close the current Workbook |
Ctrl + X | Cut Selected cells |
Ctrl + Y | Redo last action |
Ctrl + Z | Undo last action |
Ctrl + F1 | Expand/Collapse Ribbon |
Ctrl + F10 | Maximize Current workbook window |
Ctrl + F2 | Open Print preview window |
Ctrl + F3 | Define name |
Ctrl + F4 | Close current workbook |
Ctrl + F9 | Minimize Current workbook window |
Ctrl + Home | Move to First cell of a worksheet |
Ctrl + Page Down | Go to Next worksheet |
Ctrl + Page Up | Go to Previous worksheet |
Ctrl + ‘ | Copy formula/content from the above cell |
Ctrl + – | Display Delete dialog |
Ctrl + . | Toggle through edges of selection (Clockwise direction) |
Ctrl + / | Select Row differences |
Ctrl + ; | Enter current date into a cell |
Ctrl + [ | Select direct precedents |
Ctrl + \ | Select current Array |
Ctrl + ] | Select direct dependents |
Ctrl + ` | Show formulas |
Ctrl + ↑ | Move to Top edge of Data region |
Ctrl + → | Move to right edge of Data region |
Ctrl + → | Move one word right |
Ctrl + ↓ | Move to Bottom edge of Data region |
Ctrl + ← | Move to left edge of Data region |
Ctrl + ← | Move one word left |
Ctrl + End | Move to last cell used in a worksheet |
Ctrl + Enter | Confirm Entry and Stay in the cell |
Ctrl + Enter | Enter the same data into Multiple cells |
Ctrl + Space | Select entire column/columns |
Ctrl + Tab | Go to Next workbook |
Ctrl + Tab | Move to next Tab |
Read more about Excel Shortcuts…