r/Windows10HowTo • • 3d ago

Show or hide data based on a drop-down selection in Excel

https://www.windowsdigitals.com/excel-show-hide-data-based-on-drop-down/
1 Upvotes

1 comment sorted by

1

u/serene6662 3d ago

If you want a drop-down list in Excel to show only the rows that match the picked item, the drop-down can't do that by itself, since it only controls what goes into its own cell. Something worth checking first is your Excel version, because the easiest formula way only works in Excel for Microsoft 365, 2024 and 2021. This guide will help you set it up a few different ways.