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

Get FREE Advanced Excel Exercises with Solutions!

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.

Table of Contents hide

Download Practice Workbook

2 Ways to Copy Comments to Another Cell in Excel

1. Copy Comments with Paste Special Feature in Excel

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

Things to Remember

Conclusion

Download Practice Workbook

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

Copy Comments to Another Cell.xlsm

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.

After that, the comments will get copied as follows.

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.

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.