Shortcut keys in MS excel to improve your efficiency at work

Shortcut keys in MS excel to improve your efficiency at work

Here is another mind blowing blog with some reliable information on Shortcut keys in MS excel. Do not worry I will not talk about Cut, Copy, Paste. It is beyond that. I am 100% sure that after reading these shortcut keys your work efficiency will improved to a significant extent.

I also request you to open an excel sheet with some dummy data and use these shortcut keys. Please also read my another blog on Shortcut keys in SAP.

Vaibhav is an engineer by schooling and an SAP Consultant by training with 12 years of experience. He is certified in SAP PM and SAP MM. His expertise includes SAP PM, SAP MM, SAP QM, and MS excel. His industry specialties are Chemical, Automobile, Electronics and Infrastructure. He has lots of experience in SAP Training and Consulting.

Nnice job, Vaibhav. Very useful and clearly explained.
Just let me add a word about the locale input: these shortcuts will not work same way on all types of keyboard. Some commands are common (e.g. Ctrl + C; Ctrl + S, etc..) and shared on all types, just like the common set of ASCII characters, but what if one uses an AZERTY keyboard, or an Italian QWERTY? It will simply be impossible to replicate the proper sequence. of keys.
Furthermore, MS Excel comes with a localized set of formulas and syntax, and not always these are easy-to-understand, particularly when an improper translation from native version occurs.
It would be very worth to build a comparison table where all shortcuts are listed according to language, locale input method and keyboard.

Mishra, Vaibhav•April 12, 2016••Author

Thanks Raffaele. You have raised a very valid point. I do not have much knowledge about language issues. I will explore it and update the post accordingly.