- 2 hrs ago Oppo A54 India Launch Pegged For April 19; Price Tipped To Start At Rs. 13,490
- 5 hrs ago How To Activate National Roaming On BSNL Prepaid And Postpaid Mobile Numbers
- 6 hrs ago Flipkart Smartphone Carnival April Sale: Discount Offers On High End Smartphones
- 6 hrs ago Premium Smartphone Sales Might Decline Due To Delhi Lockdown
- Finance What is Demand Draft Validity Period?
- Sports IPL 2021: DC vs PBKS: Preview, Timing, Live telecast, Live streaming, Mumbai pitch report
- News Madhya Pradesh: Remdesivir injections 'stolen' from govt hospital
- Movies Ayushmann Khurrana Reunites With His Badhaai Ho Co-Star Sanya Malhotra; Read Details Inside
- Automobiles Hyundai Car Offer & Discounts For April 2021: Benefits Of Up To Rs 1.5 Lakh On Select Models
- Education Bangalore University UG And PG Exams Postponed Indefinitely
- Lifestyle Ramadan 2021: Is It Safe For People With Diabetes To Fast? COVID-19, Associated Risks And Management
- Travel 10 Best Places To Visit In Manali In April
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.
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