Excel In Seconds Tips and Tricks from The Excel Addict - Microsoft Excel 2003, 2007, 2010, 2013, 2016, 365

November 17, 2015

TheExcelAddict.com Quote of the Day
"Inspiration exists,
but it must find you working."
-- Pablo Picasso --

Hi fellow Exel Addict,

Francis Hayes (TheExcelAddict.com)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."

How true!

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

Excel in Seconds with TheExcelAddict.com

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.

nother 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.

Keyboard Shortcut Shift F10 Right Click Context Menu in Microsoft Excel 2003, 2007, 2010, 2013, 365
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.

Thanks for supporting this newsletter and website

Subscription Information: Spreadsheet Tips From An Excel Addict is available only to subscribers of my newsletter. If this newsletter was forwarded to you and you would like to get your own copy, please visit TheExcelAddict.com or send a blank email to theexceladdict(AT)aweber.com

 If you would like to share this newsletter with others...
1) Share a link to this page
2) Ask your friend/colleague to visit TheExcelAddict.com or send a blank email to theexceladdict(AT)aweber.com
3)  Post a link to TheExcelAddict.com in a company newsletter or website.

Earnings Disclosure: Some of the resources I recommend on my website and in my newsletter pay me a small referral commission if you purchase from them through links on my website or using my referral code. This helps offset the costs of my website. I've worked long and hard to build up my reputation online over the past 10 years as someone who provides exceptional value to my readers. So I'm not willing to risk that for a few dollars. As you know, I don’t just recommend anything. It has to be of outstanding quality and value. If you are ever not completely satisfied with anything I recommend, please let me know and I will get your money back for you...GUARANTEED. You can't lose.
 'Spreadsheets Tips From An Excel Addict' and 'Excel in Seconds' are publications of TheExcelAddict.com.
Copyright Francis Hayes All Rights Reserved.
8 Lexington Place, Conception Bay South, Newfoundland, Canada, A1X 6A2 Phone: 709-834-4630