How to Add Comment in Excel (4 Handy Methods)

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.


Download Practice Workbook

You can download the practice workbook from the link below.


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.

how to add comment in excel


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.

Using right click

  • 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”.

Using right click

Read More: Difference Between Threaded Comments and Notes in Excel


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.

Using Review Tab

  • 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”.

Using Review Tab

Read More: Creating and Editing Excel Comments to Cells – [An Ultimate Guide]!


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”.

how to add comment using shortcut keys

Read More: [Solved:] Insert Comment Not Working in Excel (2 Simple Solutions)


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.

Using VBA code

  • 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

Using VBA code to add comment

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

Using VBA code

Read More: How to Populate Comment from Another Cell in Excel (and Vice Versa)


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.


Related Articles

Sowmik Chowdhury
We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo