Shortcuts are time savers. It is pretty irritating to be interrupted by constant need to move back and forth the mouse over the menu and ribbons to look for mundane tasks of inserting tables or frequently required actions. There are over 180 shortcuts keys in Excel 2010 for easy navigation. However, not all of them are useful ones. Some of them are for highly specialized use.
Right from Excel 2007 where the ribbon menu was introduced, key tips were also introduced for easy navigation using Excel shortcuts. When you press ALT, the ribbon gets these alphabets corresponding to the different tabs. For example, the Home tab gets an H. When you press H, you will see the previous set of alphabets disappear and being replaced by another alphabet key tips corresponding to the sub tabs in the home tab.
You don’t have to hold down the ALT key. Just press it once and the key tips are displayed. To go back to the previous key tip, press Esc. Sometimes, for formatting the exact cell, you might need to select the cell first and then start with the key tip.
The shortcuts that begin with Ctrl key are universal and will work on Excel 2010. For example, Ctrl+v is for paste, Ctrl+n is for new workbook, Ctrl+c is for copy, Ctrl+o is for opening an .xlsx and Ctrl+s is for saving.
If you are new to key tips, then groping your way to the right menu might be irritating. Hence, here are some list of frequently used shortcut keys in excel that you might find handy.
Shortcuts keys for navigating the worksheet
Most people know how to go about entering data, but do not simple keyboard shortcuts in Excel that are easy to use and time saving.
Entering data
Formula
These are some of the shortcuts for Excel that can help save you time.
The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.