Creating a drop down list using Microsoft Excel

This is pretty simple. My demo is using the main page.

First, create all the comments you want to show in the drop down list. For my instance, I am using cell A1, A2, A3 and A4.

Next, enter a comment before the drop down list, which I have done mine in cell C1 with the comment call "Types of comments:".

Next, go to the cell next to C1 (D1, duh). Click on Data Validation

After you click on Data Validation, select List in the Allow: field under the Settings tab.

Click on the button on the extreme right to select your source of rows or columns. 

Select the desired range of rows or columns, and click on the icon at the right side of the Data Validation box.

 Click on OK to proceed.

 Now a drop down list will appear in cell D1.

If you think the comments shouldn't be appearing in the main sheet, easy. Right click on column A, select  Hide to hide the column where you are keeping all your comments.