Shortcuts that you can use for your daily tasks
1 | CTRL*A | Select All | |
2 | CTRL+C | Copy all Cells in Highlighted Area | |
3 | CTRL+V | Paste Copied Data | |
4 | CTRL+B | Bold all Cells in Highlighted Area | |
5 | CTRL+D | Fills content of upper cell in selected cell. CTRL + D (i.e. Ctrl* Down) | |
6 | CTRL+R | Fill Content of right cell in selected cell. CTRL + R (i.e. Ctrl* Right) | |
7 | CTRL+U | Underline content in selected cells | |
8 | CTRL+P | ||
9 | CTRL+F | Find in Current Sheet (Opens Dialog Box) | |
10 | CTRL+G | Open “Go to” dialog box (Go to any area, cells or name range) | |
11 | CTRL+H | Opens Find & Replace dialog box | |
12 | CTRL+I | Change text /Content format in selected cells into italic | |
13 | CTRL+K | Opens “Insert Hyperlink’ dialog Box (Insert hyperlink) | |
14 | CTRL+S | Saves open workbook | |
15 | CTRL+W | Closes current workbook | |
16 | CTRL+X | Cuts all cells in selected area / section | |
17 | CTRL+Y | Repeats the last entry/action performed | |
18 | CTRL+Z | Undo last entry/action performed | |
19 | CTRL+1 | Change cells format (Opens Format Cells dialog box) | |
20 | Ctrl+2 | Bolds all cells in the highlighted section. | |
21 | Ctrl+3 | Puts italics all cells in the highlighted section. | |
22 | Ctrl+4 | Underlines all cells in highlighted section. | |
23 | Ctrl+5 | Puts a strikethrough all cells in the highlighted section. | |
24 | Ctrl+6 | Shows or hides objects. | |
25 | Ctrl+7 | Shows or hides the toolbar. | |
26 | Ctrl+8 | Toggles the outline symbols. | |
27 | Ctrl+9 | Hides rows. | |
28 | Ctrl+0 | Hides columns. | |
29 | Ctrl+Shift+: | Enters the current time. | |
30 | Ctrl*; | Enters the current date. | |
31 | Ctrl** | Changes between displaying cell values or formulas in the worksheet. | |
32 | Ctrl+’ | Copies a formula from the cell above. | |
33 | Ctrl+Shift+” | Copies value from cell above. | |
36 | Ctrl+- | Deletes the selected column or row. | |
35 | Ctrl+Shift+» | Inserts a new column or row. | |
36 | Ctrl+Shift+- | Switches between showing Excel formulas or their values in cells. | |
37 | Ctrl+Shift+@ | Applies time formatting. | |
38 | Ctrl+Shift+! | Applies comma formatting. | |
39 | Ctrl+Shift+$ | Applies currency formatting. | |
60 | Ctrl+Shift+# | Applies date formatting. | |
61 | Ctrl+Shift+% | Applies percentage formatting. | |
62 | Ctrl+Shift+A | Applies exponential formatting. | |
63 | Ctrl+Shift+* | Selects the current region around the active cell. | |
66 | Ctrl+Shift+& | Places border around selected cells. | |
65 | Ctrl+Shift+ | Removes a border. | |
66 | Ctrl++ | Insert. | |
67 | Ctrl+- | Delete. | |
68 | Ctrl+Shift+( | Unhide rows. | |
69 | Ctrl+Shift+) | Unhide columns. | |
50 | Ctrl +/ | Selects the array containing the active cell. | |
51 | CtrlA | Selects the cells that have a static value or don’t match the formula in the active cell. | |
52 | Ctrl + [ | Selects all cells referenced by formulas in the highlighted section. | |
53 | Ctrl + ] | Selects cells that contain formulas that reference the active cell. | |
56 | Ctrl*Shift + { | Selects all cells directly or indirectly referenced by formulas in the highlighted section. | |
55 | Ctrl + Shift + } | Selects cells which contain formulas that directly or indirectly reference the active cell. | |
56 | Ctrl + Shift + | (pipe) | Selects the cells within a column that don’t match the formula or static value in the active cell. | |
57 | Ctrl + Enter | Fills the selected cells with the current entry. | |
58 | Ctrl + Spacebar | Selects the entire column. | |
59 | Ctrl + Shift + Spacebar | Selects the entire worksheet. | |
60 | Ctrl+Home | Move to cell At. | |
61 | Ctrl+End | Move to last cell on worksheet. | |
62 | Ctrl + Tab | Move between Two or more open Excel files. | |
63 | Ctrl + Shift + Tab | Activates the previous workbook. | |
64 | Ctrl + Shift + A | Inserts argument names into a formula. | |
65 | Ctrl + Shift + F | Opens the drop-down menu for fonts. | |
66 | Ctrl+Shift+O | Selects alt of the cells that contain comments. | |
67 | Ctrl+Shift + P | Opens the drop-down menu for point size. | |
68 | Shift+lnsert | Pastes what is stored on the clipboard. | |
69 | Shift+Page Up | In a single column, highlights all cells above that which are selected. | |
70 | Shift + Page Down | In a single column, highlights all cells above that which are selected. | |
71 | Shift+Home | Highlights all text to the left of the cursor. | |
72 | Shift + End | Highlights all text to the right of the cursor. | |
73 | Shift + Up Arrow | Extends the highlighted area up one cell. | |
76 | Shift + Down Arrow | Extends the highlighted area down one cell. | |
75 | Shift + Left Arrow | Extends the highlighted area left one character. | |
76 | Shift + Right Arrow | Extends the highlighted area right one character. | |
77 | Alt+Tab | Cycles through applications. | |
78 | Alt+Spacebar | Opens the system menu. | |
79 | Alt+Backpspace | Undo. | |
80 | Alt+Enter | While typing text in a cell, pressing Alt+Enter will move to the next line, allowing for multiple lines of text in one cell. | |
81 | Alt + – | Creates a formula to sum all of the above cells. | |
82 | Alt + ’ | Allows formatting on a dialog box. | |
83 | FI | Opens the Help menu. | |
86 | F2 | Edits the selected cell. | |
85 | F3 | After a name has been created. F3 will paste names. | |
86 | F6 | Repeats last action. For example, if you changed the color of text in another cell, pressing F6 will change the text in cell to the same color. | |
87 | F5 | Goes to a specific cell. For example. C6. | |
88 | F6 | Move to the next pane. | |
89 | F7 | Spell check selected text or document. | |
90 | F8 | Enters Extend Mode. | |
91 | F9 | Recalculates every workbook. | |
92 | F10 | Activates the menu bar. | |
93 | F11 | Creates a chart from selected data. | |
96 | F12 | Save as. | |
95 | Shift+FI | Opens the “What’s This?” window. | |
96 | Shift+F2 | Allows the user to edit a cell comment. | |
97 | Shift+F3 | Opens the Excel formula window. | |
98 | Shift+F5 | Brings up a search box. | |
99 | Shift+F6 | Move to previous pane. | |
100 | Shift+F8 | Add to selection. | |
101 | Shift+F9 | Performs calculate function on activesheet. | |
102 | Ctrl+F3 | Open Excel Name Manager. | |
103 | Ctrl+F6 | Closes current Window. | |
106 | Ctrl+F5 | Restores window size. | |
105 | Ctrl+F6 | Next workbook. | |
106 | Ctrl+Shift+F6 | Previous workbook. | |
107 | Ctrl+F7 | Moves the window. | |
108 | Ctrl+F8 | Resizes the window. | |
109 | Ctrl+F9 | Minimize current window. | |
110 | Ctrl+FlO | Maximize currently selected window. | |
111 | Ctrl+F11 | Inserts a macro sheet. | |
112 | Ctrl+F12 | Opens a file. | |
113 | Ctrl+Shift+F3 | Creates names by using those of either row or column labels. | |
116 | Ctrl+Shift+F6 | Moves to the previous worksheet window. | |
115 | Ctrl+Shift+F12 | Prints the current worksheet. | |
116 | AU+F1 | Inserts a chart. | |
117 | AU+F2 | Save as. | |
118 | AU+F6 | Exits Excel. | |
119 | AU+F8 | Opens the macro dialog box. | |
120 | AU+F11 | Opens the Visual Basic editor. | |
121 | Alt+Shift+F1 | Creates a new worksheet. | |
122 | Alt+Shift+F2 | Saves the current worksheet. |