How to Add Comment in Excel (4 Handy Methods)

Get FREE Advanced Excel Exercises with Solutions!

When an Excel workbook is used by many people, adding a comment makes the workbook very user-friendly. You can add comments to let other people know about your thoughts on any particular cell. This article demonstrates 4 methods of how to add a comment in Excel.

Table of Contents hide

Download Practice Workbook

4 Methods to Add Comment in Excel

1. Using Context Menu to Add Comment in Excel

2. Utilizing the Review Tab

3. Using Shortcut Keys to Add Comment in Excel

4. Applying VBA Code

Conclusion

Download Practice Workbook

You can download the practice workbook from the link below.

Add Comment.xlsm

4 Methods to Add Comment in Excel

Suppose, you have a list of employees mentioning their active or inactive status. Now, you want to add a comment In Maternity Leave to the Status of an Inactive employee Joana in cell C7. In the following stages of this article, I will show you 4 handy methods to do so.

1. Using Context Menu to Add Comment in Excel

One of the fastest ways to add a comment is using the Right-Click on the mouse. Now, follow the steps mentioned below to use this method.

Steps:

First, select the cell you want to add a comment to. In this case, select cell D7. Here, D7 is the cell showing the status of the employee Joana.
Then, Right Click on your mouse and select New Comment from the options.

At this point, type your comment in the box first and then click the Post button below or simply press CTRL + ENTER. In this case, the comment is “In Maternity Leave”.

2. Utilizing the Review Tab

You can also use the Review tab to add a comment. To add a comment using the Review tab follow the steps below sequentially.

Steps :

First, select the cell you want to add a comment to. Here, the cell is D7.
Next, select the Review tab from the top of the page and then select New Comment.

Then, first type your comment in the box and then click the Post button below or simply press CTRL + ENTER. In this case, the comment is “In Maternity Leave”.

Similar Readings

3. Using Shortcut Keys to Add Comment in Excel

Another fast method to add a comment is to use the Shortcut Keys. Now, follow the steps below to add a comment using the Shortcut Keys.

Steps :

At the very beginning, select the cell you want to add a comment to. In this case, the cell is D7.
Now, press ALT > R > C
Type your comment in the box first and then click the Post button below or simply press CTRL + ENTER. In this case, the comment is “In Maternity Leave”.

4. Applying VBA Code

You can also use VBA code to add a comment. Now, follow the steps mentioned below to add a comment using the VBA code.

Steps :

Press ALT + F11 to open the Visual Basic.
Now, select Sheet 5. Here, Sheet 5 is the Sheet you want to add a comment to.
After that, Right-Click on Sheet 5 and sequentially select Insert > Module.

After that, copy the following code and paste it into the blank box.

'This Code Will Add a Comment
Sub AddingComment()
    Range("D7").AddCommentThreaded ("In Maternity Leave")
    'Change the cell "D7" to select your desired cell
    'Change the text "In Maternity Leave" to add your comment
End Sub

Finally, go to your worksheet. Then take your cursor on cell D7 and you will see your comment.

Conclusion

I hope you got what you were looking for from this article. If you have any queries please drop a comment below. For more articles like this, visit our website ExcelDemy.