Skip to main content

Posts

How to create a drop-down list in Excel Sheet

In web forms, surveys, and polls, it can be very useful to limit the choices for a selection with a simple drop-down list. This is also possible in a Microsoft Excel spreadsheet, but the process isn't very well known or very intuitive. 

In Access, you can limit user entries by forcing users to choose a value from a list control. Office applications use the same functionality in built-in drop-down lists. For instance, the Highlight and Font Color controls on most Formatting toolbars use this flexible tool. Simply click the small triangle to the right of the icon to display a list of choices. 

Disclosure: Tech Volks may earn a commission from some of the products featured on this page. Tech Volks and the author were not compensated for this independent review.

You can create the same type of control for your users in an Excel sheet, but the process isn't intuitive. The option is in the Data Validation feature. Fortunately, once you know the feature exists, it's …