What's the shortcut in excel to show/hide cell comments?

Question

what's the shortcut in excel to show/hide cell comments?

Solution 1

Alt+V, C

This works as a toggle command.

Solution 2

Shift-F2 to edit them... otherwise i think you have to use the right click options.

Solution 3

I'm running Excel 2013 and on the ribbon's REVIEW tab I have a "Show/Hide Comment" to toggle visibility of a single cell's comment.

Shortcut: Alt, R, H

Solution 4

A modification on Geoffrey van Wyk's VBS - toggles only comment of active cell

Sub Show_Hide_Comment()
'
' This macro toggles the display of selected cell's comment if one exists.
' It does not create one if there is none... for this press Ctl+F2
'
' You may use macros menu to set keyboard shortcut
'
  If Not ActiveCell.Comment Is Nothing Then
    If ActiveCell.Comment.Visible Then
        ActiveCell.Comment.Visible = False
    Else
        ActiveCell.Comment.Visible = True
    End If
  End If
End Sub

View more solutions

Comments

[thenonhacker]

This is Ribbon shortcut. I prefer the classic one (Shift-F2), it still works with the Ribbon. :)

[Geoffrey]

This does not show or hide the existing comments.

[CodeHunt]

@thenonhacker it also puts the cursor in the comment though, so you have to do shift-f2 followed by escape twice.