Excel 2007: Create Comments that Appear When Cell is Activated

Posted January 23, 2007 by Rob Rogers in Microsoft Excel

Regular comments in Excel place a small indicator in the desired cell and require you to either mouseover the indicator or to use the Ribbon to view the comment. Some situations dictate that the comment appear when the cell is activated. by using Excel’s Data Validation, this can be easily done, just follow these instructions…


1. Select the cell that you want to attach the comment.

2. Go to the Ribbon and select the Data tab.

3. In the Data Tools section, click Data Validation.

4. In the Data Validation dialog box, select the Input Message tab.

5. Check the Show input message when cell is selected checkbox.

6. Enter a title for your comment in the Title textbox.

7. Enter the comment in the Input message box.

8. Click OK.

Now whenever that cell is activated, the comment will appear. When another cell is activated, the comment will disappear.

 

About Rob Rogers

Once a prolific author here on Tech-Recipes, Rob has moved on to greener pastures.
View more articles by Rob Rogers

The Conversation

Follow the reactions below and share your own thoughts.

  • AK

    Very helpful, thanks

  • sudip

    Why not Excel Options – advance – Display and check box select “Indicators only, and comment on hover” for Cells with Comment: show

  • Anonymous

    excel 2007 is very easy

  • Anonymous

    Microsoft Office Excel 2007 is a powerful tool you can use to create and format spreadsheets, and analyze and share information to make more informed decisions. With the Microsoft Office Fluent user interface, rich data visualization, and PivotTable views, professional-looking charts are easier to create and use. Office Excel 2007, combined with Excel Services, a new technology that will ship with Microsoft Office SharePoint Server 2007, provides significant improvements for sharing data with greater security.mobile phone

  • Damien

    Great tip but I ahve an issue.
    I have 2 cells, on 2 different location of a single sheet with a message.
    Problem: both messages appear on the same location, whether you select one cell or the other.
    The message is different but its position the same.
    Any idea on how to have a specific positioning, like next to the cell selected?

    Thanks

  • Caned

    Better late then sorry, first hit on google, did excactly what i needed, Cheers mate!