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

Related Posts

Find and Replace Multiple Values

This post will guide you how to find and replace multiple values at once with VBA macro or using formula  in Excel. How do I make multiple find and replace in Excel. Suppose that you have a few cells containing ...

VBA Macro For VLOOKUP From Another Sheet

In the previous post, you should know that how to fix or remove the #N/A error when using VLOOKUP formula to lookup value from another sheet. And this post will show you how to use VBA code to vlookup data ...

How To Insert Comments in Protected Worksheet in Excel

This post will show you how to allow comments in a protected worksheet in Excel. You can easily to insert comments into cells in a normal worksheet in Excel, but if want to insert a comment in a worksheet that ...

How To Convert Text to Upper Cases(Using VBA) in Excel

This post will show you how to switch from lower case to upper case in Excel. and I am going to show you two different ways of converting text to upper cases using formula or VBA macro in Excel 2013,Excel ...

How To Hide Every Other Row in Excel (Using VBA)

This post will show you how to hide alternate rows or columns in Excel or how to hide every third, fourth, fifth row or column in Excel. If you want to hide every other row in your current worksheet, how ...

Comments

So empty here ... leave a comment!

Leave a Reply

Sidebar