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.
- 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.
- 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:
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.
Copies the range selected by the user.
Activates the Paste command.
Paste the comments only from the copied cells.
Application.CutCopyMode = False
Exits from the Copy-Paste command.
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.
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.
- Extract Comments from Word Document into Excel
- How to Read Full Comment in Excel (6 Handy Methods)
- Hide Comments in Excel (4 Quick Methods)
- Find Comments in Excel (4 Easy Methods)
- How to Extract Comments in Excel (3 Suitable Examples)
- [Fixed!] Comments in Excel Far Away from Cell (3 Possible Solutions)
- Creating and Editing Excel Comments to Cells – [An Ultimate Guide]!