Most Useful Excel Keyboard Shortcuts
Excel keyboard shortcuts can greatly enhance your productivity and efficiency when working with spreadsheets. Here are some of the most useful Excel keyboard shortcuts:
| No. | Shortcut | Description |
|---|---|---|
| 1 | Ctrl + C | Copy selected cells. |
| 2 | Ctrl + X | Cut selected cells. |
| 3 | Ctrl + V | Paste copied or cut cells. |
| 4 | Ctrl + Z | Undo the last action. |
| 5 | Ctrl + Y | Redo the last action. |
| 6 | Ctrl + S | Save the current workbook. |
| 7 | Ctrl + N | Create a new workbook. |
| 8 | Ctrl + O | Open an existing workbook. |
| 9 | Ctrl + P | Print the current workbook. |
| 10 | Ctrl + F | Find data within the worksheet. |
| 11 | Ctrl + H | Replace data within the worksheet. |
| 12 | Ctrl + A | Select the entire worksheet. |
| 13 | Ctrl + Shift + + | Insert new rows/columns. |
| 14 | Ctrl + – | Delete selected rows/columns. |
| 15 | Ctrl + Shift + L | Turn on/off filters (Excel tables). |
| 16 | Ctrl + Space | Select the entire column. |
| 17 | Shift + Space | Select the entire row. |
| 18 | Ctrl + Shift + Arrow keys | Extend selection to the last non-empty cell. |
| 19 | Ctrl + Home | Go to the top-left cell of the worksheet. |
| 20 | Ctrl + End | Go to the last cell with data on the worksheet. |
| 21 | Ctrl + Page Up | Switch to the previous worksheet. |
| 22 | Ctrl + Page Down | Switch to the next worksheet. |
| 23 | Alt + Enter | Start a new line within a cell. |
| 24 | F2 | Edit the active cell. |
| 25 | F4 | Repeat the last action. |
| 26 | Ctrl + 1 | Open the Format Cells dialog box. |
| 27 | Ctrl + Shift + $ | Apply currency format. |
| 28 | Ctrl + Shift + % | Apply percentage format. |
| 29 | Ctrl + Shift + # | Apply date format. |
| 30 | Ctrl + Shift + @ | Apply time format. |
| 31 | Alt + E, S, V | Paste special values. |
| 32 | Alt + E, S, T | Paste special formulas. |
| 33 | Alt + D, F, F | Insert a filter (Excel tables). |
| 34 | Alt + D, P, S | Page Setup options. |
| 35 | Alt + D, H, H | Hide selected rows/columns. |
| 36 | Alt + D, H, U | Unhide hidden rows/columns. |
| 37 | Alt + H, B | Apply bold formatting. |
| 38 | Alt + H, F, C | Clear formatting. |
| 39 | Alt + H, N, C | Merge cells. |
| 40 | Alt + Arrow keys | Navigate between cells. |
These shortcuts will help you work more efficiently with Excel, and memorizing them will save you time and effort while working with spreadsheets.