| S.no. |
Schortcut key |
Action |
S.no |
Shortcut key |
Action |
| 1 |
Open Run box |
type: excel |
123 |
CTRL+SHIFT+} |
Select cells that contain formulas that directly or indirectly reference the active cell.
|
| 2 |
Ctrl+: |
Insert Current Time |
124 |
ALT+; |
Select the visible cells in the current selection. |
| 3 |
Ctrl+A |
Select All |
125 |
SHIFT+BACKSPACE |
With multiple cells selected, select only the active cell. |
| 4 |
Ctrl+B |
Bold |
126 |
CTRL+SHIFT+SPACEBAR |
Selects the entire worksheet. If the worksheet contains data, |
| 5 |
Ctrl+C |
Copy |
127 |
CTRL+SHIFT+SPACEBAR |
selects the current region. Pressing |
| 6 |
Ctrl+D |
Fill Down |
128 |
CTRL+SHIFT+SPACEBAR |
a second time selects the entire worksheet. When an object is selected, |
| 7 |
Ctrl+F |
Find |
129 |
CTRL+SHIFT+SPACEBAR |
selects all objects on a worksheet |
| 8 |
Ctrl+G |
Goto |
130 |
Shortcut key |
Action |
| 9 |
Ctrl+H |
Replace |
131 |
Ctrl+A |
Select All |
| 10 |
Ctrl+I |
Italic |
132 |
Ctrl+B |
Bold |
| 11 |
Ctrl+K |
Insert Hyperlink |
133 |
Ctrl+C |
Copy |
| 12 |
Ctrl+N |
New Workbook |
134 |
Ctrl+D |
Fill Down |
| 13 |
Ctrl+O |
Open |
135 |
Shortcut key |
Action |
| 14 |
Ctrl+P |
Print |
136 |
Ctrl+H |
Replace |
| 15 |
Ctrl+R |
Fill Right |
137 |
Ctrl+I |
Italic |
| 16 |
Ctrl+S |
Save |
138 |
Ctrl+K |
Insert Hyperlink |
| 17 |
Ctrl+U |
Underline |
139 |
Ctrl+N |
New Workbook |
| 18 |
Ctrl+V |
Paste |
140 |
Ctrl+O |
Open |
| 19 |
Ctrl W |
Close |
141 |
Ctrl+P |
Print |
| 20 |
Ctrl+X |
Cut |
142 |
Ctrl+R |
Fill Right |
| 21 |
Ctrl+Y |
Repeat |
143 |
Ctrl+S |
Save |
| 22 |
Ctrl+Z |
Undo |
144 |
Ctrl+U |
Underline |
| 23 |
F1 |
Help |
145 |
Ctrl+V |
Paste |
| 24 |
F10 |
Activate Menubar |
146 |
Ctrl W |
Close |
| 25 |
F11 |
New Chart |
147 |
Ctrl+X |
Cut |
| 26 |
F12 |
Save As |
148 |
Ctrl+Y |
Repeat |
| 27 |
F2 |
Edit |
149 |
Ctrl+Z |
Undo |
| 28 |
F3 |
Paste Name |
150 |
F1 |
Help |
| 29 |
F4 |
Repeat last action |
151 |
F2 |
Edit |
| 30 |
F4 |
While typing a formula, switch between absolute/relative refs |
152 |
F3 |
Paste Name |
| 31 |
F5 |
Goto |
153 |
F4 |
Repeat last action |
| 32 |
F6 |
Next Pane |
154 |
F4 |
While typing a formula, switch between absolute/relative refs |
| 33 |
F7 |
Spell check |
155 |
F5 |
Goto |
| 34 |
F8 |
Extend mode |
156 |
F6 |
Next Pane |
| 35 |
F9 |
Recalculate all workbooks |
157 |
F7 |
Spell check |
| 36 |
Ctrl+" |
Copy Value from Cell Above |
158 |
F8 |
Extend mode |
| 37 |
Ctrl+’ |
Copy Formula from Cell Above |
159 |
F9 |
Recalculate all workbooks |
| 38 |
Shift |
Hold down shift for additional functions in Excel’s menu |
160 |
F10 |
Activate Menubar |
| 39 |
Shift+F1 |
What’s This? |
161 |
F11 |
New Chart |
| 40 |
Shift+F2 |
Edit cell comment |
162 |
F12 |
Save As |
| 41 |
Shift+F3 |
Paste function into formula |
163 |
Ctrl+: |
Insert Current Time |
| 42 |
Shift+F4 |
Find Next |
164 |
Ctrl+; |
Insert Current Date |
| 43 |
Shift+F5 |
Find |
165 |
Ctrl+" |
Copy Value from Cell Above |
| 44 |
Shift+F6 |
Previous Pane |
166 |
Ctrl+' |
Copy Formula from Cell Above |
| 45 |
Shift+F8 |
Add to selection |
167 |
Shift |
Hold down shift for additional functions in Excel's menu |
| 46 |
Shift+F9 |
Calculate active worksheet |
168 |
Shift+F1 |
What's This? |
| 47 |
Ctrl+Alt+F9 |
Calculate all worksheets in all open workbooks, regardless of whether they have changed
since the last calculation.
|
169 |
Shift+F2 |
Edit cell comment |
| 48 |
Ctrl+Alt+Shift+F9 |
Rechecks dependent formulas and then calculates all cells in |
170 |
Shift+F3 |
Paste function into formula |
| 49 |
Shift+F10 |
Display shortcut menu |
171 |
Shift+F4 |
Find Next |
| 50 |
Shift+F11 |
New worksheet |
172 |
Shift+F5 |
Find |
| 51 |
Shift+F12 |
Save |
173 |
Ctrl+F |
Find |
| 52 |
Ctrl+F3 |
Define name |
174 |
Shortcut key |
Action |
| 53 |
Ctrl+F4 |
Close |
175 |
Shift+F8 |
Add to selection |
| 54 |
Ctrl+F5 XL, |
Restore window size |
176 |
Shift+F9 |
Calculate active worksheet |
| 55 |
Ctrl+F6 |
Next workbook window |
177 |
Ctrl+Alt+F9 |
Calculate all worksheets in all open workbooks, regardless of whether they have changed
since the last calculation.
|
| 56 |
Shift+Ctrl+F6 |
Previous workbook window |
178 |
Ctrl+Alt+Shift+F9 |
Rechecks dependent formulas and then calculates all cells in all open workbooks, including
cells not marked as needing to be calculated.
|
| 57 |
Ctrl+F7 |
Move window |
179 |
Shift+F10 |
Display shortcut menu |
| 58 |
Ctrl+F8 |
Resize window |
180 |
Shift+F11 |
New worksheet |
| 59 |
Ctrl+F9 |
Minimize workbook |
181 |
Shift+F12 |
Save |
| 60 |
Ctrl+F10 |
Maximize or restore window |
182 |
Ctrl+F3 |
Define name |
| 61 |
Ctrl+F11 |
Inset 4.0 Macro sheet |
183 |
Ctrl+F4 |
Close |
| 62 |
Ctrl+F12 |
File Open |
184 |
Ctrl+F5 XL, |
Restore window size |
| 63 |
Alt+F1 |
Insert Chart |
185 |
Ctrl+F6 |
Next workbook window |
| 64 |
Alt+F2 |
Save As |
186 |
Shift+Ctrl+F6 |
Previous workbook window |
| 65 |
Alt+F4 |
Exit |
187 |
Ctrl+F7 |
Move window |
| 66 |
Alt+F8 |
Macro dialog box |
188 |
Ctrl+F8 |
Resize window |
| 67 |
Alt+F11 |
Visual Basic Editor |
189 |
Ctrl+F9 |
Minimize workbook |
| 68 |
Ctrl+Shift+F3 |
Create name by using names of row and column labels |
190 |
Ctrl+F10 |
Maximize or restore window |
| 69 |
Ctrl+Shift+F6 |
Previous Window |
191 |
Ctrl+F11 |
Inset 4.0 Macro sheet |
| 70 |
Alt+Shift+F1 |
New worksheet |
192 |
Ctrl+F12 |
File Open |
| 71 |
Alt+Shift+F2 |
Save |
193 |
Alt+F1 |
Insert Chart |
| 72 |
Alt+= |
AutoSum |
194 |
Alt+F2 |
Save As |
| 73 |
Ctrl+` |
Toggle Value/Formula display |
195 |
Alt+F4 |
Exit |
| 74 |
Shortcut key |
Action |
196 |
Alt+F8 |
Macro dialog box |
| 75 |
Ctrl+Shift+A |
Insert argument names into formula |
197 |
Alt+F11 |
Visual Basic Editor |
| 76 |
Alt+Down arrow |
Display AutoComplete list |
198 |
Ctrl+Shift+F3 |
Create name by using names of row and column labels |
| 77 |
Alt+’ |
Format Style dialog box |
199 |
Ctrl+Shift+F6 |
Previous Window |
| 78 |
Ctrl+Shift+~ |
General format |
200 |
Ctrl+Shift+F12 |
Print |
| 79 |
Ctrl+Shift+! |
Comma format |
201 |
Alt+Shift+F1 |
New worksheet |
| 80 |
Ctrl+Shift+@ |
Time format |
202 |
Alt+Shift+F2 |
Save |
| 81 |
Ctrl+Shift+# |
Date format |
203 |
Alt+= |
AutoSum |
| 82 |
Ctrl+Shift+$ |
Currency format |
204 |
Ctrl+` |
Toggle Value/Formula display |
| 83 |
Ctrl+Shift+% |
Percent format |
205 |
Ctrl+Shift+A |
Insert argument names into formula |
| 84 |
Ctrl+Shift+^ |
Exponential format |
206 |
Alt+Down arrow |
Display AutoComplete list |
| 85 |
Ctrl+Shift+& |
Place outline border around selected cells |
207 |
Alt+' |
Format Style dialog box |
| 86 |
Ctrl+Shift+_ |
Remove outline border |
208 |
Ctrl+Shift+~ |
General format |
| 87 |
Ctrl+Shift+* |
Select the current region around the active cell. In a PivotTable report, select the entire
PivotTable report.
|
209 |
Ctrl+Shift+! |
Comma format |
| 88 |
Ctrl++ |
Insert |
210 |
Shortcut key |
Action |
| 89 |
Ctrl+- |
Delete |
211 |
Ctrl+Shift+# |
Date format |
| 90 |
Ctrl+1 |
Format cells dialog box |
212 |
Ctrl+Shift+$ |
Currency format |
| 91 |
Ctrl+2 |
Bold |
213 |
Ctrl+Shift+% |
Percent format |
| 92 |
Ctrl+3 |
Italic |
214 |
Ctrl+Shift+^ |
Exponential format |
| 93 |
Ctrl+4 |
Underline |
215 |
Ctrl+Shift+& |
Place outline border around selected cells |
| 94 |
Ctrl+5 |
Strikethrough |
216 |
Ctrl+Shift+_ |
Remove outline border |
| 95 |
Ctrl+6 |
Show/Hide objects |
217 |
Ctrl+Shift+* |
Select current region |
| 96 |
Ctrl+7 |
Show/Hide Standard toolbar |
218 |
Ctrl++ |
Insert |
| 97 |
Ctrl+8 |
Toggle Outline symbols |
219 |
Ctrl+- |
Delete |
| 98 |
Ctrl+9 |
Hide rows |
220 |
Ctrl+1 |
Format cells dialog box |
| 99 |
Ctrl+0 |
Hide columns |
221 |
Ctrl+2 |
Bold |
| 100 |
Ctrl+Shift+( |
Unhide rows |
222 |
Ctrl+3 |
Italic |
| 101 |
Ctrl+Shift+) |
Unhide columns |
223 |
Ctrl+4 |
Underline |
| 102 |
Alt or F10 |
Activate the menu |
224 |
Ctrl+5 |
Strikethrough |
| 103 |
Ctrl+Tab |
In toolbar: next toolbar In a workbook: activate next workbook |
225 |
Ctrl+6 |
Show/Hide objects |
| 104 |
Shift+Ctrl+Tab |
In toolbar: previous toolbar |
226 |
Ctrl+7 |
Show/Hide Standard toolbar |
| 105 |
Shortcut key |
Action |
227 |
Ctrl+8 |
Toggle Outline symbols |
| 106 |
Tab |
Next tool |
228 |
Ctrl+9 |
Hide rows |
| 107 |
Shift+Tab |
Previous tool |
229 |
Ctrl+0 |
Hide columns |
| 108 |
Enter |
Do the command |
230 |
Ctrl+Shift+( |
Unhide rows |
| 109 |
Alt+Enter |
Start a new line in the same cell. |
231 |
Ctrl+Shift+) |
Unhide columns |
| 110 |
Ctrl+Enter |
Fill the selected cell range with the current entry. |
232 |
Alt or F10 |
Activate the menu |
| 111 |
Shift+Ctrl+F |
Font Drop Down List |
233 |
Ctrl+Tab |
In toolbar: next toolbar |
| 112 |
Shift+Ctrl+F+F |
Font tab of Format Cell Dialog box |
234 |
Shift+Ctrl+Tab |
In toolbar: previous toolbar |
| 113 |
Shift+Ctrl+P |
Point size Drop Down List |
235 |
Ctrl+Tab |
In a workbook: activate next workbook |
| 114 |
Ctrl+Spacebar |
Select the entire column |
236 |
Shift+Ctrl+Tab |
In a workbook: activate previous workbook |
| 115 |
Shift+Spacebar |
Select the entire row |
237 |
Tab |
Next tool |
| 116 |
CTRL+/ |
Select the array containing the active cell. |
238 |
Shift+Tab |
Previous tool |
| 117 |
CTRL+SHIFT+O |
Select all cells that contain comments. |
239 |
Enter |
Do the command |
| 118 |
CTRL+\ |
In a selected row, select the cells that don’t match the formula or static value in the
active cell.
|
240 |
Alt+Enter |
Start a new line in the same cell. |
| 119 |
CTRL+SHIFT+| |
In a selected column, select the cells that don’t match the formula or static value in the
active cell.
|
241 |
Ctrl+Enter |
Fill the selected cell range with the current entry. |
| 120 |
CTRL+[ |
Select all cells directly referenced by formulas in the selection. |
242 |
Shift+Ctrl+F |
Font Drop Down List |
| 121 |
CTRL+SHIFT+{ |
Select all cells directly or indirectly referenced by formulas in the selection. |
243 |
Shift+Ctrl+F+F |
Font tab of Format Cell Dialog box |
| 122 |
CTRL+] |
Select cells that contain formulas that directly reference the active cell. |
244 |
Shift+Ctrl+P |
Point size Drop Down List |