Microsoft Excel is a very powerful tool that can be even more powerful and faster by using Excel shortcuts. Using Excel keyboard shortcuts allows you to edit Excel worksheets quickly, faster than just using a mouse.
Table of Contents
Basic shortcuts
| Ctrl + S | Save the Excel file |
| Ctrl + C | Copy the selected cell(s) to the clipboard |
| Ctrl + V | Paste the clipboard contents |
| Ctrl + Alt + V | Paste special dialog box |
| Ctrl + Z | Undo the last action |
| Ctrl + F | Open the find tool (to search for text within the spreadsheet) |
| Ctrl + A | Select all cells |
Cell formatting
| Ctrl + B | Make selected cell(s) bold font |
| Ctrl + I | Make selected cell(s) italic font |
| Ctrl + U | Make selected cell(s) underlined |
| Ctrl + Shift + & | Add border around selected cell(s) |
| Alt + H + B + A | Add border around and in between all selected cell(s) |
| Alt + H + W | Wrap text in cell |
| F2 | Edit selected cell |
| F4 | Toggle absolute cell references |
Worksheet navigation
| Ctrl + → | Move selected cell to right end of populated cell area |
| Ctrl + ← | Move selected cell to left end of populated cell area |
| Ctrl + ↑ | Move selected cell to top of populated cell area |
| Ctrl + ↓ | Move selected cell to bottom end of populated cell area |
Worksheet formatting
| Shift + Ctrl + → | Extend selected cells to right edge of populated cell area |
| Shift + Ctrl + ← | Extend selected cells to left edge of populated cell area |
| Shift + Ctrl + ↑ | Extend selected cells to top edge of populated cell area |
| Shift + Ctrl + ↓ | Extend selected cells to bottom edge of populated cell area |
| Ctrl + space bar | Select the entire row |
| Shift + space bar | Select the entire column |
| Ctrl + Shift + + | Insert new cell (if cells selected) Insert new row (if row selected) Insert new column (if column selected) |
| Ctrl + Shift + – | Delete cell (if cells selected) Delete row (if row selected) Delete column (if column selected) |