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 install Power Dropdown for free.
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.