November 17, 2015
Hi fellow Exel Addict,
I really appreciate that you are taking time to read today's edition of my 'Excel in Seconds' newsletter.
I know from my own experience that most Excel users say they 'don't have the time' to read newsletters or search for new ways to help them with Excel.
But strangely, they DO have time to spend working on tasks that will take them hours, when in fact, shortcuts exist that would allow them to finish their work in a fraction of that time.
A while back I saw this quote on a cartoon, "The only thing worse that training employees and losing them, is NOT training them and keeping them."
Thank YOU for being an Excel Addict!
Keep on Excelling,
Francis Hayes (The Excel Addict)
If you missed my last newsletter, you can click here to view it online.
You can access even more tips on my website by going to my members' page.
Access Excel's Right-Click Menus From Your Keyboard
I have always said that Excel users should know both a mouse method and a keyboard method for performing their most frequent tasks. So you may have wondered, "How can I access that menu I get when I right-click on something, if I'm not using my mouse?"
Depending on what you have selected, when you right-click, you may get a different menu. That is called a 'context menu'.
You can open the context menu using your keyboard by pressing SHIFT+F10.
Another keyboard option that may be available to you is the 'application key'. Some Windows keyboards have a key next to the right CTRL key and most people have no idea what it's for. The key usually has an icon that looks like a menu. Pressing this key will display the context menu for whatever you have selected.
Once the context menu is displayed, you can use the arrow keys on your keyboard or the 'accelerator keys' (i.e. underlined letters in menus) to move through the options.
To access the sub-menus, simply press the right arrow key. To execute a command on the menu, select it and press the Enter key.
| 'Spreadsheets Tips
Excel Addict' and 'Excel in Seconds' are publications of
Copyright Francis Hayes All Rights Reserved.
8 Lexington Place, Conception Bay South, Newfoundland, Canada, A1X 6A2 Phone: 709-834-4630