100 Useful Microsoft Excel Shortcuts

By Nadeem On Feb 15, 2021 Last updated Feb 15, 2021 310 0

Excel Shortcuts. In the journey of learning Microsoft Excel, we learn a lot of functions and keywords. We learn several techniques to handle and manipulate data. It will be really helpful if we learn to use shortcuts. So here I am with 100 shortcuts. These shortcuts are collected for Windows users. Let us begin.

100 Excel Shortcuts

	Keyword	For
1	Control + N	Create New Workbook
2	Control + O	Open a Workbook
3	Control + S	Save a Workbook
4	Control + B	Turn the highlighted Cell in Bold
5	Control + C	Copy Highlighted Cell
6	Control + D	Fill the selected cell with the content of the cell right above.
7	Control + F	Shortcut to Find in Find and Replace Window
8	Control + G	Shortcut to Go to Window
9	Control + H	Shortcut to Replace in Find and Replace Window
10	Control + I	Shortcut to Make the content italic
11	Control + K	Insert Hyperlink in a Cell
12	Control + L	To Create New Table
13	Control + P	Print a Workbook
14	Control +R	Fill the selected cell with the content of the cell on the left.
15	Control + U	Underline Highlighted Text
16	Control + V	To paste anything that was copied
17	Control + W	Close the current Workbook
18	Control + Y	To undo Control + Z
19	Control + Z	To Undo Recent Action
20	Control + 1	To Open Format Cell Window
21	Control + 2	Alternative to Control + B
22	Control + 3	Alternative to Control + I
23	Control + 4	To underline the selected cell text
24	Control + 5	Put a strikethrough in a cell.
25	Control + 8	To show the outline symbols.
26	Control + 9	Hide a Row
27	Control + 0	Hide a Column
28	Control + Shift + :	Enter the current time in a cell.
29	Control + ;	Enter the current date in a cell.
30	Control + Shift + “	Copy the formula from the cell above.
31	Control + –	Delete Column or Row
32	Control + Shift + +	Insert Column or Row
33	Control + Shift + ~	Switch between displaying Excel formulas or their values in the cell.
34	Control + Shift + @	To apply time formatting.
35	Control + Shift + !	To apply Comma Formatting in numbers in the cell.
36	Control + Shift + $	To apply Currency formatting in the cell.
37	Control + Shift + #	To apply date formatting in the cell.
38	Control + Shift + %	To apply percentage formatting in the cell.
39	Control + Shift + &	To apply the border in the cell.
40	Control + Shift + _	To remove the border from the cell.
41	Control + Spacebar	To select the entire column.
42	Control + Shift + Spacebar	To select the entire sheet.
43	Control + Home	To move to cell A1.
44	Control + Shift + Tab	Switch to the previous workbook.
45	Control + Shift + F	Open the fonts menu under format cells.
46	Control + Shift + O	Select the cells containing comments.
47	Control + Drag	Drag and copy a cell or to a duplicate worksheet.
48	Control + Shift + Drag	Drag and insert copy.
49	Control + Up Arrow	To go to the topmost cell in a current column.
50	Control + Down Arrow	To jump to the last cell in a current column.
51	Control + Left Arrow	To jump back to the first cell in a selected row.
52	Control + Right Arrow	To go to the last cell in a selected row.
53	Control + End	To go to the last cell in a workbook.
54	Alt + Page down	To move the screen towards the right.
55	Alt + Page Up	To move the screen towards the Left.
56	Control + F2	To open print preview Window.
57	Control + F1	To expand or collapse the ribbon.
58	Alt	To see the Shortcuts for Menu and Toolbox.
59	Tab	To move to the next cell.
60	Alt + F + T	To open the options.
61	Alt + Down Arrow	Activate Filters for Cell.
62	Alt + H + H	To open the background color pallet.
63	Alt + H + B	To open the cell border pallet.
64	Alt + M + F	To insert a function.
65	Alt + A + V + V	To open the data validation window.
66	Alt + A + R + A	To refresh the sheet.
67	Alt + F + C	To close the Microsoft Excel.
68	Alt + N + V	To create a pivot table.
69	Alt + M + U + S	To enter the sum formula in the cell.
70	Alt + M + U + A	To enter the average formula in the cell.
71	Alt + M + U + C	To enter the count numbers formula in the cell.
72	Alt + M + U + M	To enter the max formula in the cell.
73	Alt + M + U + I	To enter the min formula in the cell.
74	Alt + M + U + F	To insert formula in the cell.
75	Control + Alt + +	To zoom into the sheet.
76	Control + Alt + –	To zoom out from the sheet.
77	Alt + 1	To turn on autosave.
78	Alt + 2	To save the workbook.
79	Alt + F + E	To export the workbook.
80	Alt + F + Z	To share the workbook.
81	Alt + Y + W	To know what’s new in Microsoft Excel.
82	Alt + Y + H	To open the help menu.
83	Alt + R + C	To add a comment into the cell.
84	Alt + P + O	To change the page orientation.
85	Alt + N + T	To insert a table.
86	Alt + H + 5	To align the cell text to the left.
87	Alt + H + 6	To align the cell text to the right.
88	Alt + M + T	To find text formulas.
89	Alt + M + K	To find error checking.
90	Alt + M + N	To open name manager.
91	Alt + M + L	To find logical functions.
92	Alt + M + I	To find account functions.
93	Alt + H + FC	To open text color pallet.
94	Alt + H + AR	To align the text to the right.
95	Alt + H + AL	To align the text to the left.
96	Alt + H + AC	To align the text to the center.
97	Alt + A + X	To check existing connections.
98	Alt + M + K	To do error checking.
99	Alt + A + SS	To open the sorting window.
100	Alt + P + M	To set the page margin.

I hope the Excel shortcuts in this article will be helpful for you. Please leave a comment for any suggestions or feedback. Check out our previous articles as well.

Suggested Article – What is Vlookup and how to use it?