Microsoft Excel is a powerful spreadsheet application that offers numerous shortcut keys to increase productivity and streamline tasks. Here are some essential shortcut keys for MS Excel:
General Shortcuts: | ||
1 | New Workbook | Ctrl + N |
2 | Open Workbook | Ctrl + O |
3 | Save Workbook | Ctrl + S |
4 | Save As | F12 |
5 | Close Workbook | Ctrl + W |
6 | Cut | Ctrl + X |
7 | Copy | Ctrl + C |
8 | Paste | Ctrl + V |
9 | Undo | Ctrl + Z |
10 | Redo | Ctrl + Y |
11 | Bold | Ctrl + B |
12 | Italic | Ctrl + I |
13 | Underline | Ctrl + U |
14 | Increase Font Size | Ctrl + Shift + > |
15 | Decrease Font Size | Ctrl + Shift + < |
16 | Format Cells | Ctrl + 1 |
17 | Insert Current Date | Ctrl + ; |
18 | Insert Current Time | Ctrl + Shift + ; |
19 | AutoSum | Alt + = |
20 | Fill Down | Ctrl + D |
21 | Fill Right | Ctrl + R |
22 | Select Entire Row | Shift + Space |
23 | Select Entire Column | Ctrl + Space |
24 | Insert New Row | Ctrl + Shift + + |
25 | Insert New Column | Ctrl + Shift + + |
26 | Delete Selected Row | Ctrl + - |
27 | Delete Selected Column | Ctrl + - |
28 | Navigate to Next Worksheet | Ctrl + PgDn |
29 | Navigate to Previous Worksheet | Ctrl + PgUp |
30 | Go to Cell A1 | Ctrl + Home |
31 | Go to Last Cell in Data Region | Ctrl + End |
32 | Find | Ctrl + F |
33 | Replace | Ctrl + H |
34 | Insert Hyperlink | Ctrl + K |
35 | Hide Rows | Ctrl + 9 |
36 | Unhide Rows | Ctrl + Shift + ( |
37 | Hide Columns | Ctrl + 0 |
38 | Unhide Columns | Ctrl + Shift + ) |
39 | Insert Function | Shift + F3 |
40 | Move to Next Pane (Split Window) | F6 |