Today we will discuss 40 Most Important Shortcut Keys in MS Excel Everyone Should Know. Keyboard shortcuts saves a lot of time. Using keyboard shortcuts instead of mouse will make typing easier and faster.

40 Most Important Short Cut Keys Every Microsoft Excel Users Must Know

Sr.No.	Keyboard Shortcut	Function of Shortcut Key
1	CTRL + N	To Create a new Workbook [New File]
2	CTRL + O	To open an existing Workbook in Excel
3	CTRL + S	To Save an Excel Workbook. If workbook is not saved yet, it will ask filename and location to save the workbook for first time. If you have saved workbook already with a filename, it will save any changes occurred since last save.
4	CTRL + W	To Close the selected workbook window.
5	F12	To display Save As obrolan box, You can save the workbook with a new name and / or on a different location.
6	CTRL + F2	To show Print Preview
7	CTRL + P	To display Print obrolan box you can set different print options like page size, margin size, number of copies etc and print worksheet.
8	ALT + F4	To Exit from Excel
9	CTRL + F1	To collapse or expand Ribbon
10	CTRL + A	Select all, To select entire current worksheet
11	CTRL + C	Copy contents of selected cells
12	CTRL + X	Cut contents of selected cells
13	CTRL + V	Paste copied or cut contents from clipboard
14	CTRL + ALT + V	Show paste special obrolan box
15	CTRL + F	Find, To display Find dialogbox
16	CTRL + H	Replace, To show Find / Replace obrolan box. Replace option selected. You can replace occurrences of an existing word by a new word easily.
17	SHIFT+SPACE	To Select entire current row
18	CTRL + SPACE	To Select entire current column
19	CTRL + V	Paste copied or cut contents from clipboard
20	SHIFT+F11	To insert new worksheet
21	CTRL + PageDown	To go to next worksheet
22	CTRL + PageUp	To go to previous worksheet
23	F7	To show Spelling check obrolan box
24	SHIFT+F7	To display Thesaurus obrolan box
25	ALT+Enter	To insert a line break in a cell
26	CTRL + Z	To undo last action
27	CTRL + Y	To redo last action
28	F1	To show Help obrolan box
29	F10	To activate the sajian bar
30	CTRL + G	To display go to obrolan box
31	CTRL + ;	Insert current date in a cell
32	CTRL + Shift + ;	Inserts current time in a cell
33	CTRL + B	To apply / toggle  bold text on contents of selected cells
34	CTRL + U	To apply / toggle  underline text on contents of selected cells
35	CTRL + I	To apply / toggle  italic text on contents of selected cells
36	CTRL + K	To show Insert Hyperlink obrolan box
37	F2	To edit the active cell
38	Esc	To cancel
39	CTRL + 5	To apply strike through in selected cells
40	CTRL + 1	To show Format cells obrolan box