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

Excel is the most widely used tool when it comes to dealing with huge datasets. We can perform myriads of tasks of multiple dimensions in Excel. Sometimes, we need to insert comments in Excel for our convenience. But, sometimes the insert comment option in the context bar does not work. In this article, I am going to show you 2 effective solutions for insert comment not working in Excel.

Download Practice Workbook

Download this workbook to practice while going through this article.

Possible Reasons for Insert Comment Not Working in Excel

Let’s first discuss the core issue. Normally, we often need to insert a comment in a cell for our own sake. These comments help others comprehend several facts pertaining to the dataset. You can insert a new comment or note from the context bar (see the image below).

However, sometimes, you will discover that these options are not in the context bar (see the image below)

This may occur if the version you are operating does not have the feature. Other reasons might be the add-ins and customization of the settings.
If this happens, you will be unable to add any comments or notes. So I will address this issue in this article.

2 Quick Solutions for Insert Comment Not Working in Excel

This is the dataset for this article.

Now, I will illustrate 2 essential solutions if you encounter the problem.

1. Run a VBA Macro Code

To deal with this issue, I will use VBA macros.

Steps:

• Press ALT + F11 to open the VBA window.
• Then go to Insert >> select Module.

• A new module will open. Write down the following code.

Sub VisibleAddComment()
   Dim X As CommandBar
   For Each X In Application.CommandBars
         X.Reset
   Next
End Sub

• Now, press F5 to run the code.
• Then go back to your worksheet and bring the context bar by right-clicking your mouse. This time you will see the New Comments and New Note.

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

2. Use Keyboard Shortcut to Solve Insert Comment Not Working Problem

Now in this section, we will apply two different keyboard shortcuts to enable the insert comment option in excel.

2.1 Apply SHIFT+F2 Shortcut

If you do not find the New Comment option in the context bar, you can use keyboard shortcuts instead.

Steps:

• Select the cell where you want to add a comment. I am selecting B5.

• Now press SHIFT + F2. You will be able to insert any comment.

Read More: How to Reference Comments in Excel (3 Easy Methods)

2.2 Implement ALT+Q Shortcut

You can also insert any comment using another keyboard shortcut.

Steps:

• Select B5.

• Now press ALT + Q. A search box will open. Write “insert comment” on that box.

• On selecting the “insert comment”, you can add comments.

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

Things to Remember

• Do not forget to press the keyboard keys simultaneously.
• You can also open the visual basic window from the Developer tab. The sub procedure in the VBA code should have no space.

Conclusion

In this article, I have demonstrated 2 effective solutions for the case insert comment in Excel not working. I hope it helps everyone. And lastly, if you have any suggestions, ideas, or feedback please feel free to comment down below.

Related Articles

• How to Hide Comments in Excel (4 Quick Methods)
• Print Comments in Excel (4 Suitable Ways)
• How to Find Comments in Excel (4 Easy Methods)
• Extract Comments in Excel (3 Suitable Examples)
• [Fixed!] Comments in Excel Far Away from Cell (3 Possible Solutions)
• Copy Comments in Excel (2 Suitable Ways)
• How to Remove Comments in Excel (7 Quick Methods)