| Shortcut Keys | Use |
| Home | Move to the beginning of the row |
| Ctrl + Home | Move to the beginning of the worksheet |
| Ctrl + End | Move to the last cell in the worksheet |
| Tab | Move to the next cell |
| Shift + Tab | Move to the previous cell |
| Ctrl + Page Down | Move to the next worksheet |
| Ctrl + Page Up | Move to the previous worksheet |
| Page Down | Scroll one screen down |
| Page Up | Scroll one screen up |
| Ctrl + N | New workbook |
| Ctrl + O | Open workbook |
| Ctrl + S | Save workbook |
| Ctrl + P | |
| Ctrl + F4 | Close workbook |
| Alt + F4 | Close Excel |
| F1 | Open Help |
| Shift + Arrow Keys | Select cells in the direction of the arrow |
| Ctrl + Shift + Arrow Keys | Extend selection to the last cell with data in that direction |
| Ctrl + A | Select all |
| Ctrl + Shift + Space | Select entire table |
| Ctrl + Space | Select entire column |
| Shift + Space | Select entire row |
| F2 | Edit active cell |
| Delete | Clear cell contents |
| Ctrl + D | Fill down |
| Ctrl + R | Fill right |
| Ctrl +; | Insert current date |
| Ctrl + Shift +; | Insert current time |
| Ctrl + “+” | Insert new cell(s) |
| Ctrl + – | Delete cell(s) |
| Alt + Enter | Insert line break in a cell |
| Ctrl + Z | Undo |
| Ctrl + Y | Redo |
| Ctrl + X | Cut |
| Ctrl + C | Copy |
| Ctrl + V | Paste |
| Ctrl + Alt + V | Paste Special |
| Ctrl + 1 | Open Format Cells dialog |
| Ctrl + B | Bold |
| Ctrl + I | Italic |
| Ctrl + U | Underline |
| Ctrl + Shift + $ | Apply Currency format |
| Ctrl + Shift + % | Apply Percentage format |
| Ctrl + Shift + ^ | Apply Exponential format |
| Ctrl + Shift + # | Apply Date format |
| Ctrl + Shift + @ | Apply Time format |
| Ctrl + Shift +! | Apply Number format |
| Alt + | AutoSum |
| Ctrl + Shift + “+” | Insert row or column |
| Ctrl + – | Delete row or column |
| Alt + H + O + I | AutoFit column width |
| Alt + H + O + W | Set column width |
| Alt + H + D + C | Delete column |
| Alt + H + D + R | Delete row |
| Ctrl + F | Open Find |
| Ctrl + H | Open Replace |
| Ctrl + K | Insert hyperlink |
| Ctrl + F2 | Print Preview |
| Ctrl + F3 | Define name for a cell or range |
| Ctrl + Shift + L | Toggle filters |
| Alt + F11 | Open Visual Basic Editor |
| Ctrl + T | Create Table |
| Alt + E + S + V | Paste Special Values |
| Ctrl + Alt + L | Refresh all data connections |
| F7 | Spell check |
| Alt + Enter | Insert new line in the same cell |
| Ctrl + Shift + “ | Copy value from cell above |
| Ctrl + Shift + & | Apply border to selected cells |
| Ctrl + Shift + _ | Remove border from selected cells |
beginning of the row
