Excel Keyboard shortcut Keys | MS office | Civil World

Microsoft Excel having so many unbelievable capabilities that are not instantly perceived. Excel Shortcut keys are most useful and usable to save the time.

Shortcut keys help to provide an easier and usually quicker method of directing and finishing commands in Microsoft Excel. Mostly we prefer to use the shortcuts as it’s kind of amazing how much time we can save by not using the mouse clicks. Keyboard shortcuts in Excel are commonly accessed by using the ALT, Ctrl, Shift, Function key and Window key.

We really liked that windows gives us multiple ways to perform the task in Excel, let’s say we want to save a file, either we can press the key “Ctrl+S” or “Shift+F11”.

In this video here amazing Shortcuts for Excel category wise, in which you will find the Excel formula shortcuts, Excel copy paste shortcuts, Excel keyboard shortcuts to insert row, Excel keyboard shortcuts to select row, Keyboard shortcuts for VBA and Excel hot keys (add more alt shortcuts to Excel).

Excel Keyboard shortcut Keys | MS office | Civil World

250 MS-Excel Keyboard Shortcuts :

S.No	Shortcut key	Description
1	Alt+F8	Macro dialog box
2	Alt+’	To open format style dialog box
3	Ctrl+1	Format cells dialog box
4	Shift+Ctrl+F+F	To open the Font tab in Format cells dialog box
5	Ctrl+Alt+V	To displays the "Paste Special" dialog box
6	Ctrl+T	To display the Create Table dialog box
7	Ctrl+Shift+F	To display the Format cells dialog box
8	Esc	Cancel the Command and close dialog box
9	Ctrl+shift+:	To insert current time
10	Ctrl+’	Fill the above formula in down
11	Ctrl+:	To insert current time
12	Ctrl+;	To insert current date
13	Ctrl+R	To fill the right
14	Ctrl+Y	To redo the last action
15	Ctrl+Delete	To delete to end of word
16	Shift+F11	To insert new worksheet
17	Shift+F12	To save the file
18	Ctrl+F12	To open the file
19	Ctrl+Shift+F12	To give the print
20	Alt+Shift+F2	To save the file
21	Ctrl+P	To print the file
22	Ctrl+S	To save the file
23	Ctrl W	To close the file
24	F12	To Save as the file
25	Ctrl+F2	To print the file
26	Page Up	Go to page up
27	Page Down	Go to page down
28	Left Arrow	Go to left
29	Right Arrow	Go to right
30	Up Arrow	Go to up
31	Down Arrow	Go to down
32	Tab	Indent
33	Enter	Go to new line
34	Ctrl+X	To cut the value
35	Ctrl+Shift+~	To convert into general format
36	Ctrl+Shift+#	To convert into date format
37	Ctrl+Shift+$	To convert into currency format
38	Ctrl+Shift+%	To convert into percent format
39	Ctrl+Shift+^	To convert into expontential format
40	Ctrl++	To insert the row
41	Ctrl+-	To delete the row
42	Ctrl+2	To make font  Bold
43	Ctrl+3	To make font  Italic
44	Ctrl+4	To underline the Font
45	Ctrl+6	To show/hide objects the View
46	Alt+Enter	To Start the new line in same cell
47	Shift+Ctrl+F	To open the Font tab in Format cells dialog box
48	Shift+Ctrl+P	To open the Font tab in Format cells dialog box
49	Ctrl+B	To make font Bold
50	Ctrl+U	To underline the font
51	Ctrl+V	To paste the data
52	Ctrl+Shift+!	To comma format
53	Shift+F2	To edit cell comment
54	Ctrl+I	To make the font Italic
55	Ctrl + Shift + 1	To format number in comma format.
56	Ctrl + Shift + 4	To format number in currency format.
57	Ctrl + Shift + 3	To format number in date format.
58	Ctrl + Shift + 5	To format number in percentage format.
59	Ctrl + Shift + 6	To format number in scientific format.
60	Ctrl + Shift + 2	To format number in time format.
61	F4	To repeat the last action
62	Ctrl+Alt+F9	To calculate the worksheet in all open workbook
63	Ctrl+Alt+Shift+F9	To rechecks dependent formula
64	Ctrl+F3	To define the name
65	Ctrl+Shift+F3	To create the names in row and column
66	Alt+=	Sum Function
67	Ctrl+`	To display formula
68	Ctrl+Shift+A	To insert the argument names into formula
69	Ctrl+'	To copy formula from cell above
70	F3	To paste name into formula
71	F9	To evaluate the part of formula
72	Shift+F3	To paste function into formula
73	Ctrl+Shift+F2	To go to last position
74	Ctrl+Shift+F8	To step out
75	Ctrl+Shift+F9	To clear all breakpoints
76	Ctrl+Shift+Enter	To Enter the Formula as an Array formula
77	Ctrl+Shift+U	Toggle Expand or Collapse formula bar
78	Alt+Down arrow	To display Auto complete list
79	Ctrl+8	To toggle outline symbols
80	Alt or F10	To activate menubar
81	Ctrl+K	To add the hyperlink
82	Ctrl+Z	To undo the last action
83	F11	To create the Chart
84	Shift	Hold down shift for additional functions
85	Shift+F4	To find next
86	Shift+F5	Find the value
87	Alt+F1	To insert chart
88	F1	To open Excel help
89	F5	To open 'Go To' dialog box
90	F7	To open spell checker dialog box
91	F10	To activate menubar
92	Shift+F7	To view object
93	Shift+F8	To add selection
94	Shift+F9	Quick watch
95	Shift+F10	To Show right click menu
96	Ctrl+F4	To close the window
97	Ctrl+F10	To activate menubar
98	Alt+F4	To close VBA
99	Alt+F6	To switch between last 2 windows
100	Alt+F11	To open VBE
101	Alt+Spacebar	Go to system menu
102	Alt+BackSpace	To undo the last action
103	Ctrl+E	To Export module
104	Ctrl+G	Display 'Go to Dialog" box
105	Ctrl+H	Replace the value
106	Ctrl+J	List Properties/Methods
107	Ctrl+L	Show Call Stack
108	Ctrl+Tab	Go to cycle windows
109	Ctrl+Shift+I	To Edit Parameter Info
110	Ctrl+Shift+J	To Edit List Constants
111	Ctrl+F1	To display or hide the ribbons
112	Alt+Shift+Right Arrow	To Group Rows or Columns
113	Alt+Shift+Right Arrow	Ungroup Rows or Columns
114	Ctrl+Shift+L	To Add/Remove the filter
115	Alt+O+C+A	To Adjust Column Width to Fit the Content
116	Alt+O+C+W	To Adjust Column Width to Specific Value
117	Alt+O+R+A	To Adjust Row Height to Fit the Content
118	Alt+O+R+E	To Adjust Row Height to Specific Value
119	Alt+D+P	To Open Pivot Table wizard
120	Alt+H, AL	Align Left
121	Alt+H, AR	Align Right
122	Alt+H- AC	Align Cight
123	Alt+H, AT	Align Top
124	Alt+H, AM	Align Middle
125	Alt+H- AB	Align Bottom
126	Alt+H, W	To wrap the text
127	Alt+H, H	Highlight Cell (change cell backgroudn color)
128	Alt+H, FC	Font Color
129	Alt+H, FS	Font Size
130	Alt+H, MM	Merge Cells - Merge
131	Alt+H, MU	Merge Cells - Unmerge
132	Alt+H, MC	Merge Cells - Merge and Center
133	Alt+H, MA	Merge Cells - Merge Across
134	Alt+H, M	To merge the text
135	Alt+H, FF	To change the font style
136	Alt+H, FS	To change the font size
137	Alt+H, FP	Fomat painter
138	Alt+Y, R	To record macro
139	Al+M, N	To Open dialog box of Name Manager
140	Alt+A,VV	To open Data Validation dialog box
141	Alt+N,V	To insert the Pivot Table
142	Alt+N,T	To insert the Table
143	Alt+N, C	To insert Column chart
144	Alt+N, B	To insert Bar chart
145	Alt+N, O	To insert Stock, Surface and Radar chart
146	Alt+N, N	To insert Line Chart
147	Alt+N, A11	To insert Area Chart
148	Alt+N, SD	To insert Combo Chart
149	Alt+N, Q	To insert Pie Chart
150	Alt+N, D	To insert Scatter Chart
151	Alt+F, N	To open new worksheet
152	Alt+F, O	To open the file
153	Alt+F, S	To save the file
154	Alt+F, A	To Save as the file
155	Alt+F, H	To share the file
156	Alt+F, E	To export the file
157	Alt+F, C	To close the file
158	Alt+F, D	To check the account
159	Alt+F, T	To open the Excel options
160	Ctrl+F7	To move window
161	Ctrl+Shift+_	To remove the outline border around selected cell
162	Ctrl+5	To apply/remove strike through formatting
163	Shift+F6	To move previous pane
164	F6	To move next pane
165	Home	Move to beginning of line
166	End	Move to end of line
167	Shift+Left Arrow	Extend selection left side
168	Shift+Right Arrow	Extend selection right side
169	Shift+Up Arrow	Extend selection up side
170	Shift+Down Arrow	Extend selection down side
171	Shift+Tab	Outdent
172	Ctrl+Shift+Arrow Key	Extend the selection of cells to the last nonblank cell in the same column or row as the active cell.
173	Alt+Tab	Move to cycle applications
174	Ctrl+Home	Top Of Module
175	Ctrl+End	End Of Module
176	Ctrl+Page Up	Go to top of current procedure in another sheet
177	Ctrl+Page Down	Go to top of current procedure in another sheet
178	Ctrl+Left Arrow	Move one word to left
179	Ctrl+Right Arrow	Move one word to right
180	Ctrl+Up Arrow	Go to up till the blank cell
181	Ctrl+Down Arrow	Go to down till the blank cell
182	Shift+Enter	Enter to Move up
183	Ctrl+Shift+&	To place the outline border around selected cell
184	Ctrl+Shift+*	To insert current time
185	Ctrl+9	To hide rows
186	Ctrl+0	To hide columns
187	Ctrl+Shift+(	To unhide rows
188	Ctrl+Shift+)	To unhide columns
189	Ctrl+Enter	To fill the selected cell range with the current entry
190	Shift+Spacebar	To select the entire row
191	CTRL+/	To select the array containing the active cell.
192	CTRL+SHIFT+O	To select all cells that contain comments.
193	CTRL+\	To select the cells that don't match the formula
194	CTRL+SHIFT+|	To select the cells that don't match the formula
195	CTRL+[	To select cells directly referenced by formulas in the selection.
196	CTRL+SHIFT+{	To select cells directly/indirectly referenced by formulas
197	CTRL+]	To select cells contain formulas directly reference the selection
198	CTRL+SHIFT+}	To select cells directly/indirectly referenced by formulas
199	ALT+;	To select the visible cells in the current selection.
200	SHIFT+BACKSPACE	To select only active cell
201	CTRL+SHIFT+SPACEBAR	To select the entire worksheet
202	Ctrl+Alt+L	To reapply the filter and sort on the current range
203	Ctrl+C	To copy the selected values
204	Ctrl+D	To fill down
205	Ctrl+"	To fill down
206	F2	To edit active cell
207	F8	To extend selection mode
208	Insert	Toggle insert mode
209	Delete	To delete the selected values
210	BackSpace	To delete previous entry
211	Shift+Insert	To paste the data
212	Shift+Home	Select from start of line
213	Shift+End	Select till end of line
214	Shift+Page Up	Select to top of module
215	Shift+Page Down	Select to end of module
216	Ctrl+A	To select all data without blanks
217	Ctrl+F	Find the value
218	Ctrl+Insert	To copy the selected values
219	Ctrl+Spacebar	Select the complete row
220	Ctrl+BackSpace	Go to delete to start of word
221	Shift+Delete	To cut the selection
222	Ctrl+Shift+Arrow key	To select the data from first active cell to last active cell
223	WK	To start the menu
224	WK+R	Run dialog box
225	WK+M	Minimize all
226	Shift+WK+M	Undo minimize all
227	WK+F1	To help
228	WK+E	To open Window Explorer
229	WK+F	To find files or folder
230	WK+D	To minimize all open windows and display the desktop
231	Ctrl+WK+F	To Find Computer
232	Ctrl+WK+Tab	To Quick launch toolbar
233	WK+Tab	Cycle through taskbar buttons
234	WK+L	To log off windows
235	WK+P	To start print manager
236	WK+C	To open Control Panel
237	WK+V	To start Clipboard
238	WK+K	To open keyboard properties dialog box
239	WK+I	To open mouse properties dialog box
240	WK+A	To start accessibility options
241	Ctrl+F5	XL, Restore window size
242	Ctrl+F6	Next workbook window
243	Shift+Ctrl+F6	Previous workbook window
244	Ctrl+F9	To minimize workbook
245	Ctrl+F11	To open VBE
246	Ctrl+Shift+F6	For Previous Window
247	Alt+Shift+F1	To open new worksheet
248	Ctrl+O	To open workbook
249	Shift+Ctrl+Tab	To activate previous workbook
250	Ctrl+N	To create new workook

⥤  Download Now  ⥢

Password : civilworld