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

Add a comment to a drop-down list in Microsoft Excel.

Microsoft Excel is a data entry and graphing tool application that is a part of the Microsoft Office software package. Users can perform advance equations and format any kind of data. You can keep track of specific data by creating a drop-down list of valid entries from a range of cells. After you've created your drop-down list you can add a comment to the cell that contains the list. The process can be accomplished in the same way for both the 2003 and 2007 versions of Excel.

Instructions

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.

References

• Microsoft Office: Create a Drop-Down List from a Range of Cells
• Microsoft Office: Office Excel 2007 Product Overview