How to create a dropdown clickable checklist that fills an Excell cell?

Question

I have a single cell A2 that needs to be filled with a string that's one or more items from a given list with 20 items. We have to manually input these values in alphabetic order separated by ";".

Is there a way that we can have a dropdown list on cell A2, that we could pick these values from a checklist, and by clicking on them, they would get inserted?

If so, how can I have this and use it for several rows (A2-A366) where each row is a different data entry for another day but with the same logic?

Answer 1

Create a Drop-down List

To create a drop-down list in Excel, execute the following steps.

1. On the second sheet, type the items you want to appear in the drop-down list.

Note: if you don't want users to access the items on Sheet2, you can hide Sheet2. To achieve this, right click on the sheet tab of Sheet2 and click on Hide.

2. On the first sheet, select cell B1.

3. On the Data tab, in the Data Tools group, click Data Validation.

The 'Data Validation' dialog box appears.

4. In the Allow box, click List.

5. Click in the Source box and select the range A1:A3 on Sheet2.

6. Click OK.

Result: