Get ALL Option in Excel Data Validation with this Crazy Trick πŸ’‘ @chandoo_
Get ALL Option in Excel Data Validation with this Crazy Trick πŸ’‘  @chandoo_
Uploaded January 2024 | Updated November 2026, 3 hours ago
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 - chandoo.org/wp/wp-content/uploads/2024/01/data-validation-with-ALL-option.xlsx

πŸ’₯ More AMAZING Excel Tricks - youtube.com/playlist?list=PLmejDGrsgFyDWz403VIRWR7wJofyDfxqt

πŸ‘©β€πŸ’» Want even more? Get my Excel School course and zoom past the rest - chandoo.org/wp/excel-school-program
Get ALL Option in Excel Data Validation with this Crazy Trick πŸ’‘This Excel Fuzzy Match Formula is CRAZY GOOD 🀩5 HR KPIs Every Analyst Needs to Master #HRAnalytics #KPIsThis Excel Trick shows the New Customers Quickly!Excel Formula to Show Top Sellers InstantlyPower Query - Advanced Tips + Q&A - REPLAYAdvanced SQL for Data Analysis - 10 Powerful Examples in 40 minutes πŸ•—How many days overlap between two projects [Excel Formula Magic]Excel + ChatGPT - 7 Ways to Work Faster & Smarter 😎How to use Power BI Visual Calculations - Easy Explanation [DAX Tricks]Advanced Pivot with GROUPBY Excel FunctionCalendar Weeks & SUMIFS - this trick is AMAZING 😍
Chandoo |

Get "ALL" Option in Excel Data Validation with this Crazy Trick πŸ’‘

SHARE TO X SHARE TO REDDIT SHARE TO FACEBOOK WALLPAPER