Is there a short cut key that allows you to toggle between comment

J

jbsand1001

I am trying to toggle between comments in Excel but I have to use the toolbar
and I wanted to see if there are any keyboard short cuts that would allow for
this?
 
B

bigwheel

jbsand1001 said:
I am trying to toggle between comments in Excel but I have to use the toolbar
and I wanted to see if there are any keyboard short cuts that would allow for
this?
Click to expand...

Have you tried right-clicking the commented cell and choosing one of the
comment options from the popup menu?
 
J

jbsand1001

Thanks, But what I really want to do is find out either what the keyboard
shortcut to pull up the "popup menu" or find a keyboard shortcut to toggle
between comments to edit.

Thanks,
 
D

David McRitchie

There is no builtin shortcut for that you would have to create your
own macros and shortcut key, or assign it to a toolbar button
Toolbars, Custom Buttons and Menus
.http://www.mvps.org/dmcritchie/excel/toolbars.htm

Sub toggle_comment_indicator()
If Application.DisplayCommentIndicator = xlNoIndicator Then
Application.DisplayCommentIndicator = xlCommentIndicatorOnly
ElseIf Application.DisplayCommentIndicator = xlCommentIndicatorOnly Then
Application.DisplayCommentIndicator = xlCommentAndIndicator
Else
Application.DisplayCommentIndicator = xlNoIndicator
End If
End Sub

You can check existing shortcuts so you don't override something else
Shortcut Keys in Excel
http://www.mvps.org/dmcritchie/excel/shortx2k.htm
 
Top