June 21, 2016
Hi fellow Excel Addict,
Welcome to summer! Yes, even in Newfoundland.
I know there are lots of places dealing with heat waves at this time of year, so I'll bet that 23°C 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)
If you missed my last newsletter, you can click here to view it online.
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.
If you have the Clear (filters) button added to your Quick Access Toolbar, that's one easy way to reset the filters.
But some people prefer keyboard shortcuts to using their mouse, so here is a shortcut you can use.
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.
| '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