Microsoft Excel 2003, 2007, 2010, 2013 Tips

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

June 21, 2016

Hi fellow Excel Addict,

Welcome to summer! Yes, even in Newfoundland.

Francis Hayes (The Excel Addict) Conception Bay South, Newfoundland, Canada
After a couple of weeks of persistent, cold northerly winds, we've made an abrupt detour into summer. On Sunday, the overnight temperature here was 2C (36F). In just over 12 hours the temperature spiked to 23C (73F) and it's been so nice ever since.

I know there are lots of places dealing with heat waves at this time of year, so I'll bet that 23C would be just heavenly. It's not to late to visit Newfoundland!

If you missed last Thursday's Excel in Minutes' tip, 'Making Your Spreadsheets Fit Your Screen', you can read it here now.

I hope you are having an awesome week where ever you are and whatever the weather you're experiencing.

Keep on Excelling,
Francis Hayes (The Excel Addict)

Francis Hayes ( Quote of the Day

"Life isn't about finding yourself.
Life is about creating yourself."

-- George Bernard Shaw --

If you missed my last newsletter, you can click here to view it online.

Excel in Seconds with

One Keyboard Shortcut That Quickly Turns On, Off and Resets Filters

If you use filtering a lot, one thing that may annoy you (just a little) is when you have filters applied on multiple columns and you want to reset these filters so you can apply different filters.

Reset Filters On Multiple Columns in Microsoft Excel 2007 2010 2013 2016 365
If you have the Clear (filters) button added to your Quick Access Toolbar, that's one easy way to reset the filters.

Clear Reset Auto Filters Quick Access Toolbar in Microsoft Excel 2007 2010 2013 2016 365

But some people prefer keyboard shortcuts to using their mouse, so here is a shortcut you can use.

Auto Filter Toggle Keyboard Shortcut in Microsoft Excel 2007 2010 2013 2016 365

CTRL+SHIFT+L is typically used to toggle filtering on and off but it also works as a nice trick for quickly resetting your filters. To reset the filters on a filtered list, press CTRL+SHIFT+L twice. The first time turns the filters off. The second time turns them back on with all filters reset.

Quick and easy!

Maybe even faster than a speeding mouse.

It's about time to learn macros in Microsoft Excel 2007 2010 2013 2016 365
Thanks for supporting this newsletter and 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
Copyright Francis Hayes All Rights Reserved.
8 Lexington Place, Conception Bay South, Newfoundland, Canada, A1X 6A2 Phone: 709-834-4630