Pasting Excel comments

Copying and pasting comments (or "notes" in newer Excel terminology) to multiple cells or across multiple worksheets can be tricky in Excel 2013, as the built-in functionality for this task is limited. Here’s how to achieve it:

Workaround to Copy and Paste Comments to Multiple Cells in Excel 2013:

1. Copy a Comment to Multiple Cells on the Same Worksheet:
• Copy the Cell with the Comment:
• Right-click the cell containing the comment and select Copy (or use Ctrl + C).
• Paste Special:
• Select the range of cells where you want to paste the comment.
• Right-click on one of the selected cells, choose Paste Special, and then select Comments (or Notes in newer versions). This will paste only the comments into the selected cells.
2. Copy a Comment to Cells on Multiple Worksheets: Unfortunately, Excel 2013 does not support pasting comments to multiple worksheets at once directly through Paste Special. However, you can try these options:
• Manually Paste Comments on Each Worksheet:
• Repeat the Paste Special > Comments process on each worksheet individually.
• Use a VBA Macro for Automation: If you need to paste the comment to the same cell across multiple worksheets, a macro can automate this task:

Vba Code is untested backup your file first

Sub CopyCommentToMultipleSheets()
    Dim ws As Worksheet
    Dim sourceCell As Range
    Dim targetRange As Range
    
    ' Specify the cell with the comment to be copied
    Set sourceCell = Worksheets("Sheet1").Range("A1")
    
    ' Loop through all worksheets
    For Each ws In ThisWorkbook.Worksheets
        If ws.Name <> "Sheet1" Then ' Exclude the source sheet if necessary
            Set targetRange = ws.Range("A1") ' Adjust the cell reference as needed
            If Not sourceCell.Comment Is Nothing Then
                ' Add or copy the comment
                targetRange.ClearComments
                targetRange.AddComment sourceCell.Comment.Text
            End If
        End If
    Next ws
End Sub

Instructions:

1. Press Alt + F11 to open the VBA editor.
2. Go to Insert > Module and paste the macro code.
3. Modify Sheet1 and A1 to match your source cell and sheets.
4. Close the editor and run the macro by pressing Alt + F8, selecting CopyCommentToMultipleSheets, and clicking Run.

Limitations and Additional Notes:

• Comments vs. Notes: Ensure you are dealing with cell comments (old-style) rather than threaded comments, as newer versions of Excel (post-2016) introduced threaded comments that may behave differently.
• Manual Approach: If the number of worksheets is limited, manually using Paste Special > Comments may be more practical without VBA.

This should help you efficiently copy and paste cell comments across multiple worksheets in Excel 2013.

The text and steps were edited with the help of AI.

My answers are voluntary and without guarantee!

Hope this will help you.

Was the answer useful? Mark as best response and Like it!

This will help all forum participants