Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

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

share|improve this question
add comment

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

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

4 Answers

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
add comment

Alt+V, C

This works as a toggle command.

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

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
add comment

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
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.