Want To Know How To Work With COMMENTS?

While working with Excel it may be necessary to brief at times why the value went up or down. In some places you may want to write some hints about the value for your own reference text. But such references will lead lot of rework while preparing instant reports. Moreover you may not like if they are visible to everyone. Microsoft Excel allows you to create short notes on each cell using a command Comment.

You can find the command in the Insert menu. You can even find it in the pop-up menu. The pop-up menu opens either right clicking your mouse or by pressing Shift key and F10 key at the same time.

Tips: By pressing Shift key and F3 key, you can directly create comment and start writing your note. You can customize the text box size, font, font size and its location. You need to type the text and press enter

You will find a red mark now on the top right corner of the cell. While moving mouse pointer nearer to the cell, Excel displays comments whatever you typed just like the above pictures.

Let us know how to manage these comments now.

To edit a comment use Shift Key and F3 function key at the same time.

You can even do by opening the pop-up menu and selecting ‘Edit Comment’ option to make necessary correction. Select ‘Delete comment’ option to delete the existing comment. Select ‘show comment’ option to keep displaying the comment in the screen.

There is a tool bar specially meant for working with comments. You can activate it by selecting comments from View menu.

Info: Always ensure that comments are not disabled in your Excel environment settings. Otherwise you may not able to see any comments even you create.

You can check the current settings for comments from the following path.

Excel => Tool menu => Options => View Tab => Comments => Comment indicator only.