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

Get FREE Advanced Excel Exercises with 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 inserting comments not working in Excel.


Possible Reasons for Insert Comment Not Working in Excel

Let’s first discuss the core issue. Normally, we often need to add comment in Excel 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 Menu (see the image below).

Insert Comment in Excel Not Working

However, sometimes, you will discover that these options are not in the Context Menu (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.


Insert Comment Is Not Working in Excel: 2 Simple Solutions

This is the dataset for this article.

Insert Comment in Excel Not Working

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

Insert Comment in Excel Not Working

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


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 Menu, you can use keyboard shortcuts instead.

Steps:

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

Insert Comment in Excel Not Working

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


2.2 Implement ALT+Q Shortcut

You can also insert any comment using another keyboard shortcut.

Steps:

  • Select B5.

Insert Comment in Excel Not Working

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

  • On selecting the “Insert Comment”, you can add comments.

Insert Comment in Excel Not Working


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.

Download Practice Workbook

Download this workbook to practice while going through this article.


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 Article


<< Go Back to How to Add a Comment in Excel | Comments in Excel | Learn Excel

What is ExcelDemy?

ExcelDemy - Learn Excel & Get Excel Solutions Center provides online Excel training , Excel consultancy services , free Excel tutorials, free support , and free Excel Templates for Excel professionals and businesses. Feel free to contact us with your Excel problems.
Akib Bin Rashid
Akib Bin Rashid

AKIB BIN RASHID, a materials and metallurgical engineer, is passionate about delving into Excel and VBA programming. To him, programming is a valuable time-saving tool for managing data, files, and internet-related tasks. Proficient in MS Office, AutoCAD, Excel, and VBA, he goes beyond the fundamentals. Holding a B.Sc in Materials and Metallurgical Engineering from Bangladesh University of Engineering and Technology, MD AKIB has transitioned into a content development role. Specializing in creating technical content centred around Excel and... Read Full Bio

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo