Get “ALL” Option in Excel Data Validation with this Crazy Trick

Microsoft Excel Tips and Tricks

Recently, I had to show “ALL” as an option in my data validation dropdowns. I used a simple but effective trick to get All items as an option. In this video, let me share the trick.

Credit Chandoo

Please support our Sponsors here :