Get “ALL” Option in Excel Data Validation with this Crazy Trick December 5, 2024 greta Excel 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 :