Share via

"Paste Cell Comments" in Quick Access Toolbar

Anonymous
2017-01-20T15:26:28+00:00

I am trying to add the "Paste Comments" command to the Excel Quick Access toolbar.

So far have been unable to identify the command in the Excel Options > Customize the Quick Access Toolbarthat allows me to paste cell comments.  

I have found the commands for the other common Paste Special paste options (such as paste formulas, paste values, paste formats), but I have not been able to find the "Paste Comments".

Could someone please direct me to the name of the command that I am looking for?

Thank you,

Scott

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments No comments

Answer accepted by question author

Anonymous
2017-01-20T15:59:00+00:00

s,

re:  pasting comments

I believe you are going to have to settle for the Paste Special button.

But that command is already available on the cell right-click menu.

For me, the right-click menu is more convenient than the QAT.

'---

Jim Cone

Portland, Oregon USA

https://goo.gl/IUQUN2 (Dropbox)

(free & commercial excel add-ins & workbooks)

Was this answer helpful?

0 comments No comments

3 additional answers

Sort by: Most helpful
  1. Anonymous
    2017-01-20T20:23:28+00:00

    Thanks Gord,

    This will be the route that I ultimately take.  

    I was hoping that there would be a QAT command so that I could always undo the action (and actions prior to the "paste comments" macro) if need be.

    Thanks again,

    Scott

    Was this answer helpful?

    0 comments No comments
  2. Anonymous
    2017-01-20T20:18:10+00:00

    Thanks Jim,

    Glad to know that that QAT Command for this doesn't actually exist, buried under an inconspicuous name.

    Thanks again,

    Scott

    Was this answer helpful?

    0 comments No comments
  3. Anonymous
    2017-01-20T16:21:15+00:00

    Interested in a macro you can attach to a custom button on the QAT?

    Sub Comment_Only_PasteSpecial()

        With Selection

            .PasteSpecial Paste:=xlPasteComments

            Application.CutCopyMode = False

        End With

    End Sub

    Gord

    Was this answer helpful?

    0 comments No comments