Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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

share|improve this question

migrated from stackoverflow.com Sep 2 '09 at 10:37

This question came from our site for professional and enthusiast programmers.

Alt+V, C

This works as a toggle command.

share|improve this answer
2  
This is Ribbon shortcut. I prefer the classic one (Shift-F2), it still works with the Ribbon. :) – thenonhacker Sep 3 '09 at 17:59

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

share|improve this answer
    
This does not show or hide the existing comments. – systemovich Sep 9 '09 at 11:25

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
share|improve this answer

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

share|improve this answer

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.

share|improve this answer
1  
-1? Why? Please explain. – systemovich Sep 4 '09 at 6:42

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .