In-cell dropdown lists are an incredibly powerful Microsoft Excel feature. Power Dropdown makes them even more powerful:
- The list is displayed in a popup window, making it more user-friendly.
- The list automatically extends to the entire table column, if your data validation list is part of a table.
- You can choose to display additional text (a “label”), next to the selectable value. From another column of the table you are picking the valid values from, for example.
- The values are deduped and you can also take labels (see above) into account while deduping.
- You can filter the list by typing. If you added labels, the filter also applies to them.
- A button can take you to the data validation list, very handy if you can’t remember where it was.
- With the Premium version, you can also pre-define filters, to limit the user choices.
Check it out:
Click here to see how to implement cascading dropdown lists using Power Dropdown.
Click here to install Power Dropdown and start your 3-month trial.
Once the trial period is over, you have the following subscription options:
- Standard subscription: 3 EUR per user per year
- Premium subscription: 6 EUR per user per year
Taxes may apply and will be calculated at checkout.
If you’d like to learn more about Power Dropdown, click here for the user guide.
Download a demo file to experience Power Dropdown using some pre-defined in-cell dropdowns.