Microsoft Excel is extensively used across the globe to store and analyze. Despite various new data analytics tools in the market, Excel remains the go-to product for working with data. It has numerous in-built features, which makes it easier for you to organize your data.
In this article, we’ll be discussing the various Excel shortcuts. These keyboard shortcuts are used to perform tasks faster and effectively.
No. | Action | Shortcut key |
1 | Create a New Workbook | Ctrl+N |
2 | Open Existing Workbook | Ctrl+O |
3 | Close the Workbook | Ctrl+W |
4 | Save the Workbook | Ctrl+S |
5 | Redo an action | Ctrl + Y |
6 | Undo an action | Ctrl+Z |
7 | Select all the contents in a Workbook | Ctrl+A |
8 | Bold the Selected Cells | Ctrl+B |
9 | Underline the Selected Cells | Ctrl+U |
10 | Italicise Highlighted Cells | Ctrl+I |
11 | Search For anything in a Workbook | Ctrl+F |
12 | Find & Replace Cell Contents | Ctrl+H |
13 | Move to Specific Line in a Workbook | Ctrl+G |
14 | Copy the Selected Cells | Ctrl+C |
15 | Paste the Selected Cells | Ctrvl+V |
16 | Cut the Content of the Selected Cells | Ctrl+X |
17 | Print Workbook | Ctrl+P |
18 | Insert Table | Ctrl+T |
19 | Fill the Selected Cell with content of the cell on the left | Ctrl+R |
20 | Quick Analysis | Ctrl+Q |
21 | Convert Multiple Lines in a cell into columns | Ctrl+J |
22 | Insert a Hyperlink in a cell | Ctrl+K |
23 | Create Table Dialog Box | Ctrl+L |
24 | Fill the Selected Cell with the content of the cell above | Ctrl+D |
25 | Freeze Panes | Alt,W and then F |
26 | UnFreezing Panes | Alt+W+F+F |
27 | Show or Hide the ribbon | Ctrl+F1 |
28 | Print Preview | Ctrl+F2 |
29 | Open “Name Manager” Dialogue Box | Ctrl+F3 |
30 | Close the Workbook | Ctrl+F4 |
31 | Restore Window Size of the Selected Workbook | Ctrl+F5 |
32 | Go to the Next Workbook Window | Ctrl+F6 |
33 | Move the Excel Window (When not maximized) | Ctrl+F7 |
34 | Resize the Window (when not maximized) | Ctrl+F8 |
35 | Minimize the Workbook to Icon | Ctrl+F9 |
36 | Maximize or restores the Workbook | Ctrl+F10 |
37 | Insert a Macrosheet | Ctrl+F11 |
38 | Open File | Ctrl+F12 |
39 | Hide Column | Ctrl+0 |
40 | Unhide Column | Ctrl+Shift+) |
41 | Hide Rows | Ctrl+9 |
42 | Unhide Rows | Ctrl+Shift+( |
43 | Format Cells | Ctrl+1 |
44 | Select Entire Column | Ctrl+Space |
45 | Select Entire Row | Shift+Space |
46 | Delete Row/Column/Cell | Ctrl+ – |
47 | Add Row/Column/Cell | Ctrl+Shift++ |
48 | Move to Next Sheet | Ctrl+ Page Down |
49 | Move to Previous Sheet | Ctrl+Page Up |
50 | Insert Current Time | Ctrl+: |
51 | Insert Current Date | Ctrl+; |
52 | Copy Value From Cell Above | Ctrl+” |
53 | Copy Formula From Cell Above | Ctrl+’ |
54 | Sum of all values | Alt+= |
55 | Inserting a Line Break | Alt +Enter |
56 | Open Filter Menus | Ctrl+Shift+L |
57 | Close Filter Menus | Alt,D,F,F |
58 | Remove Duplicates | Press Alt then A then M |
59 | Insert Chart | Alt+F1 |
60 | Save As The Workbook | Alt+F2 |
61 | Exit | Alt+F4 |
62 | Select all cells that contain comments | Ctrl+Shift+0 |
63 | Select the cells that don’t match the formula or static value in the active cell. | Ctrl+\ |
64 | To move to the edge of the next data region, but only if there are no blank cells on the worksheet. | Ctrl+Arrow Keys |
65 | To Open the Menu Box (Like the Right Click on the Mouse) | Shift+F10 |
66 | Change Font | Alt,H,F,F |
67 | Change Font Size | Alt,H,F,S |
68 | Change Font Colour | Alt,H,F,C |
69 | Fill colour in Cell/s | Alt,H,H |
70 | Remove Colour From Cell/s | Alt,H,H,N |
71 | Wrap Text/Unwrap Text | Alt,H,W |
72 | Merge cells to the centre (i.e. centre aligned after merging) | Alt,H,M,C |
73 | Merge cells to the let (i.e. left aligned after merging) | Alt,H,M,A |
74 | Unmerge Cells | Alt,H,M,U |
75 | Apply All Borders to the Cell/s | Alt,H,B,A |
76 | Apply outside thick border to cell/s | Alt,H,B,T |
77 | Apply Left thick border to cell/s | Alt,H,B,L |
78 | Apply Right thick border to cell/s | Alt,H,B,R |
79 | Apply Top thick border to cell/s | Alt,H,B,P |
80 | Apply Bottom thick border to cell/s | Alt,H,B,O |
81 | Remove Border From Cell/s | Alt,H,B,N |
82 | Increase Decimal Place | Alt,H,0 |
83 | Decrease Decimal Place | Alt,H,9 |
84 | Convert to Number Format | Ctrl+Shift+1 |
85 | Convert to Time Format | Ctrl+Shift+2 |
86 | Convert To Date Format | Ctrl+Shift+F3 |
87 | Apply Currency Symbol | Ctrl+Shift+F4 |
88 | Custom Row Height | Alt,H,O,H |
89 | Custom Column Width | Alt,H,O,W |
90 | Rename Worksheet | Alt,H,O,R |
91 | To select all the cells above the selected cell | Ctrl+Shift+Up Arrow |
92 | To select all the cells below the selected cell | Ctrl+Shift+ Down Arrow |
93 | To go to the “Tell me what you want to do” box | Alt+Q |
94 | Create Pivot Table | Alt,N,V |
95 | To group pivot table items | Alt+Shift+ Right Arrow |
96 | To ungroup pivot table items | Alt + Shift + Left arrow |
97 | To create a pivot chart on the same sheet | Alt + F1 |
98 | Apply Conditional Formatting | Alt+O+D |
99 | Format as Table | Alt,H,T |
100 | Format Cell/s Style | Alt,H,J |
Kindly Refer to
Privacy Policy &
Complete Terms of Use and Disclaimer.