You can add informational comments to particular cells in your worksheet in order to explain the meaning of data, clarify complex formulas or perhaps provide instructions to the end-user. A small red triangle appears in the top right hand corner of cells that contain comments. To display an attached comment, position your mouse pointer over the cell containing the comment. A small text box containing the comment text will then appear on your screen. To display all comments on the worksheet, select Show All Comments on the Comments group of the Review Ribbon.
To Add a Comment to a Cell
- Activate the cell to which you wish to attach a comment.
- Click the Review tab on the Ribbon.
- Click the Add Comment button on the Comment group on the Ribbon.
Or
Right-click and then choose Insert Comment from the contextual menu. - Type your comment in the comment box.
- Click outside the comment box.
Similar Posts:
- Editing and Deleting Comments in Excel 2007
- Locking and Unlocking Cells in an Excel Worksheet
- Quickly Toggle the Display of Formulas in Excel Worksheet Cells
- Inserting Voice Comments into a Word 2007 Document
- Change Worksheet Tab Color in Excel
- Using Footnotes and Endnotes in Word 2007
- Merge Cells and Center Text in Excel
{ 1 comment… read it below or add one }
Thank you for useful information. quite worked for me