How to Copy Comments to Another Cell in Excel (2 Methods)

This article illustrates how to copy comments in excel from one cell to another cell. Comments are notes to describe the cell contents. It is possible to reply to comments, unlike notes in excel. You may need to write the same comments for different cells if the contents are similar. But this will be tedious for a large dataset. Fortunately, there are ways to copy the comments from one cell to another cell in excel. Follow the article to learn about 2 such ways to do that.


Download Practice Workbook

You can download the practice workbook from the download button below.


2 Ways to Copy Comments to Another Cell in Excel

Assume you have the following dataset. Here, the marks and GPA associated with the grades are given as comments.

Now follow the methods below to learn how to copy the comments to the next cells.


1. Copy Comments with Paste Special Feature in Excel

You can copy comments from one cell to another using the Paste Special feature in excel. Follow the steps below to be able to do that.

📌 Steps

  • First, select the range B5:B9 containing the comments. Then press CTRL+C to copy the range. Next, select the cell (C5) where you want to copy the comments.

  • After that, press CTRL+ALT+V to open the Paste Special dialog box. Next, mark the radio button for Comments and Notes. Then click OK. Do not press Enter after clicking OK. Otherwise, the cell values will also get copied. Press Esc instead to avoid that.

Copy Comments with the Paste Special Feature in Excel

  • After that, the comments will get copied as follows.

Copy Comments in Excel to Another Cell

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


2. Use a VBA Code to Copy Comments to Another Cell

You can also get the same results using VBA in excel. Follow the steps below to be able to do that.

📌 Steps

  • First, press ALT+F11 to open the VBA window. Then, select Insert >> Module to create a new module as shown below.

  • After that, copy the following code using the copy button in the upper right corner.
Sub CopyCommentsInExcel()
Dim CopyRange As Range, PasteRange As Range
xTitleId = "ExcelDemy.Com"
Set CopyRange = Application.Selection
Set CopyRange = Application.InputBox("Ranges to be copied :", xTitleId, CopyRange.Address, Type:=8)
Set PasteRange = Application.InputBox("Paste to (single cell):", xTitleId, Type:=8)
CopyRange.Copy
PasteRange.Parent.Activate
PasteRange.PasteSpecial xlPasteComments
Application.CutCopyMode = False
End Sub
  • Then paste the copied code onto the blank module as shown in the picture below. Keep the cursor inside the code.

Copy Comments to Another Cell with Excel VBA

  • Now, press F5 to run the code. Then VBA will ask for the range to copy the comments from. Select the range B5:B9 and then press OK.

  • After that, VBA will ask for the location where you want to copy the comments. Select cell C5 and then press OK.

  • After that, you will get the same results as in the earlier method.

VBA Code Explanation:

Sub CopyCommentsInExcel()
We will write the code inside this subject procedure.

Dim CopyRange As Range, PasteRange As Range
Declaring necessary variables.

xTitleId = “ExcelDemy.Com”
Title for the VBA window.

Set CopyRange = Application.Selection
Assigning values to the CopyRange variable.

Set CopyRange = Application.InputBox(“Ranges to be copied :”, xTitleId, CopyRange.Address, Type:=8)
Takes user input for the CopyRange variable.

Set PasteRange = Application.InputBox(“Paste to (single cell):”, xTitleId, Type:=8)
Takes user input for the PasteRange variable.

CopyRange.Copy
Copies the range selected by the user.

PasteRange.Parent.Activate
Activates the Paste command.

PasteRange.PasteSpecial xlPasteComments
Paste the comments only from the copied cells.

Application.CutCopyMode = False
Exits from the Copy-Paste command.

End Sub
Ends the subject procedure.

Read More: How to Copy Comments in Excel Using VLOOKUP


Things to Remember

Do not press Enter after pasting the comments i.e. clicking OK in the first method. Otherwise, the cell values will also get copied. Press Esc instead to avoid that.


Conclusion

Now you know how to copy comments in excel from one cell to another cell. Please use the comment section below for further queries or suggestions. Do visit our ExcelDemy blog to explore more about excel. Stay with us and keep learning.


Related Articles

Md. Shamim Reza

Md. Shamim Reza

Hello there! This is Md. Shamim Reza. Working as an Excel & VBA Content Developer at ExcelDemy. We try to find simple & easy solutions to the problems that Excel users face every day. Our goal is to gather knowledge, find innovative solutions through them and make those solutions available for everybody. Stay with us & keep learning.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo