Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
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? |
#2
![]() |
|||
|
|||
![]()
"jbsand1001" wrote in message
... 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? Have you tried right-clicking the commented cell and choosing one of the comment options from the popup menu? |
#3
![]() |
|||
|
|||
![]()
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, "bigwheel" wrote: "jbsand1001" wrote in message ... 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? Have you tried right-clicking the commented cell and choosing one of the comment options from the popup menu? |
#4
![]() |
|||
|
|||
![]()
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 --- HTH, David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001] My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm "jbsand1001" wrote in message ... 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, "bigwheel" wrote: "jbsand1001" wrote in message ... 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? Have you tried right-clicking the commented cell and choosing one of the comment options from the popup menu? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
whats the keyboard short cut for inserting a row in Excel | New Users to Excel | |||
how do i create a short cut on my desktop for a excell file? | Excel Discussion (Misc queries) | |||
How do I toggle between sheets in Excel? | Excel Discussion (Misc queries) | |||
Status Bar - Key Board Short Cut | Excel Discussion (Misc queries) | |||
Is there a short cut to switch between worksheets? | Excel Worksheet Functions |