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.

How to Add Comment in Excel: 4 Methods

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

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