Excel 2016 For Dummies
Book image
Explore Book Buy On Amazon

You can add text comments to particular cells in an Excel 2016 worksheet. Comments act kind of like electronic pop-up versions of sticky notes. To add a comment to a cell, follow these steps:

  1. Move the cell pointer to or click the cell to which you want to add the comment.

  2. Click the New Comment command button on the Ribbon's Review tab or press Alt+RC.

    A new text box appears (similar to the one shown in the figure). This text box contains the name of the user as it appears in the User Name text box on the General tab in the Excel Options dialog box (Alt+FT) and the insertion point located at the beginning of a new line right below the user name.

  3. Type the text of your comment in the text box that appears.

  4. When you finish entering the comment text, click somewhere on the worksheet outside of the text box.

    Excel marks the location of a comment in a cell by adding a tiny triangle in the upper-right corner of the cell. (This triangular indicator appears in red on a color monitor.)

  5. To display the comment in a cell, position the thick white cross mouse or touch pointer somewhere in the cell with the note indicator.

    Adding a comment to a cell in a new text box.
    Adding a comment to a cell in a new text box.

About This Article

This article is from the book:

About the book author:

Greg Harvey, PhD is the President of Mind Over Media. Greg wrote his first computer book more than twenty years ago and since that time, he has amassed a long list of bestselling titles including Excel All-In-One For Dummies (all editions) and Excel Workbook For Dummies (all editions).

This article can be found in the category: