MS Excel Shortcut Keys: Best 15 MS Excel Keyboard Shortcut Keys You Should Know

|

Microsoft Excel is probably one of the handiest and extensively used tools today. With calculations, graph tools, tables, and many others - Microsoft Excel is an easy software for all your professional and personal work. However, having a couple of keyboard shortcuts for Microsoft Excel could make it much easier to operate.

 
Best 15 MS Excel Keyboard Shortcut Keys You Should Know

Whether you're a pro getting a hang of the keyboard shortcuts could help save time and boost productivity. And if you're a beginner, learning the keyboard shortcuts will help you navigate through MS Excel much easily. We've listed out 15 simple and easy-to-remember shortcut keys for Microsoft Excel.

 

Best 15 MS-Excel Keyboard Shortcuts

F4: Repeats the previous command, including repeating the last action.
F9: One of the most important shortcut keys, this enables you to calculate all worksheets in all open workbooks.
F11: Enables you to make a bar graph on the selected data in a separate sheet.
F12: Pops open the Save As window, allowing you to save the MS Excel file in any location you wish.
Shift + F11: This allows you to insert a new worksheet within the same MS Excel workbook.
Shift + F9: Shortcut enables calculations only in the active worksheets.
Shift + Arrow key: Adds a new cell in the direction of the Arrow key used.
Ctrl + F1: The shortcut helps to show or hide the ribbon.
Ctrl + F2: Switches to print preview.
Ctrl + Shift + U: Expands or collapses the formula bar.
Ctrl + Shift + $: Selected cells formatted as currency.
Ctrl + Shift + #: Selected cells formatted as date with day, month, year format.
Ctrl + Shift + %: Selected cells formatted as percentage.
Alt + F1: This allows you to make an embedded bar chart on the selected cells.
Alt + Q: Shortcut key opens the 'Tell me what you want to do', enabling you to search for a feature.

Bonus Shortcut Keys To Remember

Apart from these, there are a couple of basic shortcut keys that can be used across Microsoft Office. Some are listed below:

Ctrl + Z: Undo an action
Ctrl + Y: Redo an action
Ctrl + F4: Closes the opened file
Ctrl + S: Saves the file'
Ctrl + N: Opens new page

Best Mobiles in India

Best Phones

Get Instant News Updates
Enable
x
Notification Settings X
Time Settings
Done
Clear Notification X
Do you want to clear all the notifications from your inbox?
Yes No
Settings X
X