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 here
Download Word File - Click here

Excel Shortcuts

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	Apply or remove strikethrough
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	CTRL+SHIFT+@	Apply Time format
111	CTRL+SHIFT+#	Apply Date format
112	CTRL+SHIFT+^	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