How can I add a dropdown list to a cell so that the user can choose a value from the list

Type the list of valid entries in a single column. You can hide this column from the user if you wish. Select the cell or cells that will display the list of entries, choose Data ^ Validation, and then select the Settings tab. From the Allow drop-down list, select List. In the Source box, enter a range address or a reference to the items in your sheet. Make sure that the In-Cell Dropdown check box is selected. If the list is short, you can simply type the items, each separated by a comma. This technique does not require any macros.

0 0

Post a comment