Cascading drop downs enhance usability of your dashboards & interactive workbooks. A cascading drop-down is a 2 or more level selection mechanism. When you have 100s of selection choices, instead of creating one massive drop down or combo-box, you can set up multiple levels of drop downs, so that users can narrow down their selection. For example, users can select Country, State and then City using cascading drop downs.
There are many ways to setup cascading drop downs. You can use formulas coupled with either data validation or form controls. You can also use Slicers. In this video we will review these techniques.
If you use Excel 365, you can also use XLOOKUP to set up cascading drop down list in Excel. Check out this article for that technique.
Cascading drop downs in Excel – Video Tutorial:
You can also watch this video on our YouTube channel.
Download Cascading Drop Downs Example Workbook
Please click here to download the cascading drop downs workbook. Examine the named formulas & slicer settings to learn more.
Companion material to learn more
Please go thru below links to learn more about cascading drop downs in Excel.
11 Responses to “FREE Calendar & Planner Excel Template for 2025”
Hi,
I downloaded this 2025 Calendar template. I checked the custom tab. Is it possible to change the weekend Fri & Sat.
Thanks
It is. Just use the option for fri & sat weekend (should be 7).
Activities of some dates are not getting displayed on "Any month" and "printable calendar" sheets.
e.g. Activity of 24 Apr 25.
Can you check again? The date in "planner" sheet should be a proper date. When I tested with 24-apr-2025, it works.
Love this calendar... I have highlight planner dates enabled but all dates are blue, is it possible to customize the color based on the type assigned to each date?
What would be the right way to add more Holidays in the Customizations?
Inserting rows in the Holiday List causes the blank cells in the calendar to turn Blue.
This is amazing!!! The best I've seen so far!! Is it possible to update it to consider a column for the final date? That way, if an event lasts more than one day, it repeats in the calendar
How do we change/insert the customization "Icon Options" ?
You can adjust these from the settings tab.
Is there anyway this can turn into an academic calendar (ie. start month is July and runs all the way through June of next year)?
Is there a way to make it something that is more than a day without having to add it to every day of that week.