Microsoft Excel Top 180 Shortcuts | Excel Shortcuts 2023
Microsoft Excel Top 180 Shortcuts | Excel Shortcuts 2023
Download PDF File - Click here
Download Excel File - Click hereDownload Word File - Click here
|
S.NO. |
Shorcut |
Uses |
|
1 |
Ctrl+A |
Select All or Select
whole document |
|
2 |
Ctrl+B |
Bold |
|
3 |
Ctrl+C |
Copy |
|
4 |
Ctrl+D |
Fill Down |
|
5 |
Ctrl+E |
Flash Fill |
|
6 |
Ctrl+F |
Find |
|
7 |
Ctrl+G |
GO TO |
|
8 |
Ctrl+H |
Find and Replace |
|
9 |
Ctrl+I |
Italic |
|
10 |
Ctrl+K |
Insert a Hyperlink |
|
11 |
Ctrl+L |
Create OR Convert to
Table |
|
12 |
Ctrl+N |
New Workbook |
|
13 |
Ctrl+O |
Open workbook |
|
14 |
Ctrl+P |
Print |
|
15 |
Ctrl+Q |
Quick
analysis/conditional formatting |
|
16 |
Ctrl+R |
Fill Right |
|
17 |
Ctrl+S |
Save |
|
18 |
Ctrl+T |
Create OR Convert to
Table |
|
19 |
Ctrl+U |
Underline |
|
20 |
Ctrl+V |
Paste |
|
21 |
Ctrl+X |
Cut |
|
22 |
Ctrl+Y |
Redo or Repeat typing |
|
23 |
Ctrl+Z |
Undo last action |
|
24 |
Ctrl+* |
Select All |
|
25 |
Ctrl+1 |
Format Cell Dialog Box
(Ctrl+Shift+F) |
|
26 |
Ctrl+2 |
Bold |
|
27 |
Ctrl+3 |
Italic |
|
28 |
Ctrl+4 |
Underline |
|
29 |
Ctrl+5 |
|
|
30 |
Ctrl+9 |
Hide Selected Row |
|
31 |
Ctrl+Shift+9 |
Unhide Selected Row |
|
32 |
Ctrl+0 |
Hide Selected Column |
|
33 |
Ctrl+Shift+0 |
Unhide Selected Column |
|
34 |
Drag |
Drag and cut |
|
35 |
Ctrl+Drag |
Drag and copy |
|
36 |
Shift+Drag |
Drag and Insert |
|
37 |
Ctrl+Shift+Drag |
Drag and Insert Copy |
|
38 |
F1 |
Open Help Window |
|
39 |
F2 |
Edit Cell |
|
40 |
F3 |
Paste name into formula |
|
41 |
Shift+F3 |
Open function dialog box |
|
42 |
Ctrl+Shift+F3 |
Create name from
selection in row or col |
|
43 |
F4 |
Repeat Last Action and
switch between absolute/relative ref. in formula |
|
44 |
F5 |
Go to |
|
45 |
F6 |
Next Pane, Zoom Control |
|
46 |
F7 |
Spell Check |
|
47 |
F8 |
Extend Mode (Shift+F8) |
|
48 |
F9 |
Recalculate all worksheet |
|
49 |
Shift+F9 |
Calculate active
worksheet |
|
50 |
F10 |
Active Menu bar |
|
51 |
F11 |
Insert Chart in New Sheet |
|
52 |
F12 |
Save As (Alt+F2) |
|
53 |
CTRL+F11 |
Insert Macro Worksheet |
|
54 |
CTRL+F12 |
Open File Dialog box |
|
55 |
CTRL+ALT+V |
Paste Special |
|
56 |
CTRL+SHIFT+F4 |
Find Previous Match
(after initial find) |
|
57 |
SHIFT+F4 |
Find Next Match (after
initial find) |
|
58 |
CTRL+SHIFT+L |
Toggle Auto Filter |
|
59 |
ALT+↓ |
Filter Active |
|
60 |
Shift+Click |
Expend Selection |
|
61 |
Ctrl+Click |
Add non-adjacent cells to
selection |
|
62 |
Shift+F8 |
Toggle "Add to
selection" Mode (F8) |
|
63 |
Esc |
Exit add to selection
mode |
|
64 |
SHIFT+↓ |
Expend Selection Down |
|
65 |
SHIFT+↑ |
Expend Selection Up |
|
66 |
SHIFT+← |
Expend Selection Left |
|
67 |
SHIFT+→ |
Expend Selection Right |
|
68 |
Shift+PgUp |
Expend Selection up one
screen |
|
69 |
Shift+PgDn |
Expend Selection down one
screen |
|
70 |
Alt+Shift+PgUp |
Expend Selection left one
screen |
|
71 |
Ctrl+Shift+O |
Select Cells with
comments |
|
72 |
Ctrl+[ |
Select Direct precedents |
|
73 |
Ctrl+] |
Select Direct dependents |
|
74 |
Alt+; |
Select Visible cells only |
|
75 |
Esc |
Cancel Editing |
|
76 |
Alt+Enter |
Start a New line in same
Cell |
|
77 |
Ctrl+' |
Copy formula from above
cell |
|
78 |
Ctrl+Shift+" |
Copy value from above cell |
|
79 |
Ctrl+Shift+& |
Add border around
selected cell |
|
80 |
Ctrl+Shift+- |
Remove border |
|
81 |
Alt+= |
Auto Sum |
|
82 |
Ctrl+` |
Formula Display on or off |
|
83 |
Ctrl+Shift+A |
Insert formula arguments |
|
84 |
Ctrl+Shift+Enter |
Array formula |
|
85 |
Ctrl+Shift+U |
Expend or Collapse
formula bar |
|
86 |
Ctrl+Enter |
Auto Fill Selected Cell |
|
87 |
Alt+H+O+U+S |
Hide Active sheet |
|
88 |
Alt+H+O+U+H |
Unhide Active sheet |
|
89 |
Alt+I+R |
Insert Row |
|
90 |
Alt+I+C |
Insert Column |
|
S.NO. |
Shorcut |
Uses |
|
91 |
Alt+H+D+C |
Delete a column |
|
92 |
Alt+Shift+→ |
To Group Rows or Column |
|
93 |
Alt+Shift+← |
To Ungroup Rows or Column |
|
94 |
Alt+F1 |
Create Pivot Chart on the
same sheet |
|
95 |
SHIFT+SPACE |
Select Entire Row |
|
96 |
CTRL+ - |
Delete Row/delete dialog
box |
|
97 |
CTRL+ + |
Insert dialog box |
|
98 |
CTRL+SPACE |
Select Entire Column |
|
99 |
CTRL+↓ |
Move active cell down to
last fill cell |
|
100 |
CTRL+↑ |
Move active cell Up to
last fill cell |
|
101 |
CTRL+← |
Move active cell left to
last fill cell |
|
102 |
CTRL+→ |
Move active cell right to
last fill cell |
|
103 |
CTRL+SHIFT+↓ |
Select last fill cell to
down |
|
104 |
CTRL+SHIFT+↑ |
Select last fill cell to
Up |
|
105 |
CTRL+SHIFT+← |
Select last fill cell to
left |
|
106 |
CTRL+SHIFT+→ |
Select last fill cell to
right |
|
107 |
CTRL+SHIFT+$ |
Apply Currency Format |
|
108 |
CTRL+SHIFT+% |
Apply Percentage Format |
|
109 |
CTRL+SHIFT+! |
Apply Number Format |
|
110 |
Apply Time format |
|
|
111 |
Apply Date format |
|
|
112 |
Apply Scientific format |
|
|
113 |
Ctrl+Shift+: |
Insert Current Time |
|
114 |
Ctrl+Shift+~ |
General Format |
|
115 |
Ctrl+; |
Insert Current Date |
|
116 |
Alt+F2 |
Save As |
|
117 |
Alt+F4 |
Close active Window |
|
118 |
Alt+' |
Cell style Dialog box |
|
119 |
Alt+Space |
Display Control Menu |
|
120 |
Alt+O+H+R |
Rename current worksheet |
|
121 |
Alt+E+L |
Delete current worksheet |
|
122 |
Alt+E+M |
Move current worksheet |
|
123 |
Alt+P+R+S |
Set print area |
|
124 |
Ctrl+Mouse wheel up |
Zoom in |
|
125 |
Ctrl+Mouse wheel Down |
Zoom out |
|
126 |
Ctrl+Tab |
Switch Workbook/previous
workbook |
|
127 |
SceLK |
Toggle scroll lock |
|
128 |
Alt+Drag |
Drag to Worksheet |
|
129 |
Ctrl+Drag |
Drag to Duplicate
Worksheet |
|
130 |
Ctrl+Shift+F1 |
Toggle Full screen |
|
131 |
Ctrl+F1 |
Hide or Unhide Ribbon |
|
132 |
Ctrl+F2 |
Print Preview |
|
133 |
Ctrl+F3 |
Name Manager Window |
|
134 |
Ctrl+F4 |
Close workbook or file |
|
135 |
Ctrl+F5 |
Restore Down |
|
136 |
Ctrl+F6 |
Active Menu bar |
|
137 |
Shift+F7 |
Open Thesaurus |
|
138 |
Ctrl+F9 |
Minimize |
|
139 |
Ctrl+F10 |
Maximize |
|
140 |
Shift+F10 |
Open Right Click Menu |
|
141 |
Shift+F11 |
Insert a New Worksheet |
|
142 |
Alt+F11 |
VBA Code Window |
|
143 |
PgUp |
Move One screen Up |
|
144 |
PgDn |
Move One screen Down |
|
145 |
Alt+PgUp |
Move One screen Left |
|
146 |
Alt+PgDn |
Move One screen Right |
|
147 |
Shift+Backspace |
Select active cell when
multiple cells already seleted |
|
148 |
Ctrl+Backspace |
show the active cell in
worksheet |
|
149 |
Ctrl+ . |
Move active cell
clockwise to corners of selection |
|
150 |
Shift+Enter |
Move active cell to up |
|
151 |
Shift+Tab |
Move active cell to Left |
|
152 |
Home |
Move to start of row |
|
153 |
End |
Move to end of row |
|
154 |
Shift+Home |
Expend selection to start
of row |
|
155 |
Shift+End |
Expend selection to end
of row |
|
156 |
Ctrl+Home |
Move to first cell in
worksheet |
|
157 |
Ctrl+End |
Move to last cell in
worksheet |
|
158 |
Ctrl+Shift+Home |
Expend selection to first
cell in work sheet |
|
159 |
Ctrl+Shift+End |
Expend selection to last
cell in work sheet |
|
160 |
Alt+Shift+PgDn |
Expend Selection right
one screen |
|
161 |
Ctrl+Shift+* |
Select current region
(Ctrl+*) |
|
162 |
Ctrl+Shift+{ |
Select all precedents |
|
163 |
Ctrl+Shift+} |
Select all dependents |
|
164 |
Shift+F2 |
Insert or edit comments |
|
165 |
Shift+F10+M |
Delete comment |
|
166 |
Ctrl+Shift+F |
Format cell window |
|
167 |
Alt+H+A+C |
Align center |
|
168 |
Alt+H+A+L |
Align Left |
|
169 |
Alt+H+A+R |
Align Right |
|
170 |
Alt+H+W |
Wrap Text |
|
171 |
Alt+H+6 |
Indent |
|
172 |
Alt+H+5 |
Remove Indent |
|
173 |
Alt+H+A+T |
Align Top |
|
174 |
Alt+H+A+M |
Align Middle |
|
175 |
Alt+H+A+B |
Align Bottom |
|
176 |
Alt+H+F+G |
Increase font size one
step |
|
177 |
Alt+H+F+K |
Decrease font size one
step |
|
178 |
Alt+N+V |
Insert Pivot table |
|
179 |
Ctrl+PgDn |
Jump to next sheet |
|
180 |
Ctrl+PgUp |
Jump to previous sheet |
Download PDF File - Click here
Download Excel File - Click here
Download Word File - Click here
Post a Comment