If you want to be Bob Munden at Excel, use the Keyboard.. As simple as that!
If you observe most of the people that are good with Excel, you would har...
25 Excel Short Keys To Improve Speed
May 2, 2014
Reset All Slicers At Once
February 12, 2015
Slicers were a great introduction in the Excel 2010 Version. They work really really well with Pivot Tables to help you slice and dice your data very quickly.
However, if you deal with quite a few slicers on a report, you surely must have observed that currently there is no way you can reset all slicers at once. If you have 10 slicers on a report, you have to clear all 10 of those one after the other, which is very annoying.
Hence, I had to ask VBA for some help!
Put the below code on your personal macro workbook, to be able to clear all Slicers at once -