How to Insert a comment into Multiple Cells in Excel

This post will guide you how to insert a comment into two or multiple cells in Excel. How do I add comment to multiple cells with VBA Macro in Excel 2013/2016.

Insert Comment into Multiple Cells


Assuming that you have a list of data in range B1:B5, in which contain some text values, and you want to insert a comment into those cells in Excel, how to accomplish it. You can use Paste Special feature to achieve the result. Just do the following steps:

Step1: select Cell B1, and then inert into a comment. then copy this cell by pressing Ctrl + C keys on your keyboard.

insert comments into multiple cells1

insert comments into multiple cells2

Step2: select the rest cells in your range B1:B5, and then right click on it. select Paste Special menu from the context menu list, and the Paste Special dialog will open.

insert comments into multiple cells3

Step3: choose Comments option under Paste section in the Paste Special dialog box. click Ok button.

insert comments into multiple cells4

Step4: you would see that one comment has been added into all selected range of cells.

insert comments into multiple cells5

Insert Comment into Multiple Cells with VBA Macro


You can also use an Excel VBA Macro to add one comment to multiple cells in Excel. Just do the following steps:

Step1: open your excel workbook and then click on “Visual Basic” command under DEVELOPER Tab, or just press “ALT+F11” shortcut.
Get the position of the nth using excel vba1

Step2: then the “Visual Basic Editor” window will appear.

Step3: click “Insert” ->”Module” to create a new module.
export each sheet to csv2

Step4: paste the below VBA code  into the code window. Then clicking “Save” button.

insert comments into multiple cells6

 

Sub InsertCommentsIntoMultiCells()
  Set myRange = Application.Selection
  Set myRange = Application.InputBox("choose one range that you want to add comments in:", "InsertCommentsIntoMultiCells", myRange.Address, Type:=8)
    myComments = InputBox("Enter a Comment that you want to insert" & vbCrLf )

      For Each myCell In myRange
        With myCell
        .ClearComments
        .AddComment
        .Comment.Text Text:=myComments
      End With
    Next myCell
End Sub

Step5: back to the current worksheet, then run the above excel macro. Click Run button.

insert comments into multiple cells7

Step6:choose one range that you want to add comments in,such as: B1:B5. click Ok button.

insert comments into multiple cells8

Step7:Enter a Comment that you want to insert in the input box. then press Ok button.

insert comments into multiple cells9

Step8: let’s see the result:

insert comments into multiple cells10

You might also like:

Comments

So empty here ... leave a comment!

Leave a Reply

Your email address will not be published. Required fields are marked *

Sidebar