what's the shortcut in excel to show/hide cell comments?
Add a comment
|
5 Answers
Alt+V, C
This works as a toggle command.
-
4This is Ribbon shortcut. I prefer the classic one (Shift-F2), it still works with the Ribbon. :)– user9520Commented Sep 3, 2009 at 17:59
-
@thenonhacker it also puts the cursor in the comment though, so you have to do shift-f2 followed by escape twice.– willCommented Jul 4, 2017 at 13:16
Shift-F2 to edit them... otherwise i think you have to use the right click options.
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
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
In Excel 2007, there is no such keyboard shortcut according to the Excel Help File. You will have to write a macro for that.
Sub Show_Hide_Comments()
'
' This macro toggles the display of all comments that have been inserted for cells in a worksheet.
'
' Keyboard Shortcut: Ctrl+Shift+S
'
If Application.DisplayCommentIndicator = xlCommentAndIndicator Then
Application.DisplayCommentIndicator = xlCommentIndicatorOnly
Else
Application.DisplayCommentIndicator = xlCommentAndIndicator
End If
End Sub
You can paste the above code into a module in your Personal Workbook and set the shortcut in the Macros dialog. Let me know if you do not know how to do that.
-
1