How to Show a Comment Box in a Cell With a Drop Down List in Excel

1. Open the Microsoft Excel application on your computer, then open a file. Create a list of entries for the drop-down list in a single column.
2. Select the cell where you want the drop-down list to appear. Click on the 'Data' option from the top toolbar menu.
3. Click on the 'Validation' option then click on the 'Settings' tab. Click on the 'List' option from the 'Allow' box.
4. Enter a reference to your list in the 'Source' box. Click on the box next to the 'In-cell drop-down' field so it's selected.
5. Click on the 'Input Message' tab. Click on the box next to the 'Show input message when cell is selected' field so it's selected. Type the message you want and the comment box will appear in the cell.