Add drop down list / combo box into excel cell
Usually the simplest way to achieve that is to:
- prepare the list next to your table or on other spreadsheet (just input all available values in a column) - it'll be a source for your list of values and it may be hidden later, if you want
- mark a cell (or a range of cells) in which list should be displayed
- select Data > Data Validation > Data Validation
- select Allow: List
- indicate the list prepared before as a Source
- confirm
The drop-down list is ready. For combo-box you should use VBA, I believe. But you may also use the method described above and e.g. prepare just two-elements list containing "Yes/No" or "True/False", which is generally the same.
The method should work regardless of Excel's version.
Found this answer when looking to do the same thing myself, while experimenting discovered, there's a second option which means you don't need to use a defined cell range. Entries can be added directly to Source.
- Select all the cells you want to have a drop down box
- Click > Data Validation
- Allow > List
- In Source enter any values you want separated by a comma.