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.

📁 Sample File - https://chandoo.org/wp/wp-content/upl...

💥 More AMAZING Excel Tricks -    • Excel Tips & Shortcuts  

👩‍💻 Want even more? Get my Excel School course and zoom past the rest - https://chandoo.org/wp/excel-school-p...