Go Back   TechArena Community > Technical Support > Computer Help > Office Help > MS Office Support
Become a Member!
Forgot your username/password?
Register Tags Active Topics RSS Search Mark Forums Read

Sponsored Links



Show/Hide group symbols via shortcut in Excel

MS Office Support


Reply
 
Thread Tools Search this Thread
  #1  
Old 16-02-2012
Member
 
Join Date: Oct 2011
Posts: 121
Show/Hide group symbols via shortcut in Excel

Excel 2007. I know you can turn the symbols on and off using Excel Options / Advanced, but I could swear I have seen somewhere a shortcut key combination to do this much more quickly. I've scoured local help and come up short. Also can't find any reference to shortcut keys here on the forum. Anyone know of such a shortcut, or did I just dream this up.

Reply With Quote
  #2  
Old 16-02-2012
Member
 
Join Date: May 2011
Posts: 410
Re: Show/Hide group symbols via shortcut in Excel

There is way for the same. Select rows or columns, then use <Shift> <Alt> <RightArrow> to display symbols. You can also use <Shift> <Alt> <LeftArrow> to hide symbols. You need to create a proper macro for the same.
Reply With Quote
  #3  
Old 16-02-2012
Member
 
Join Date: Aug 2011
Posts: 690
Re: Show/Hide group symbols via shortcut in Excel

There is one more thing you can try. Press CTRL + 8. I will recommend you to read properly Excel shortcut and function keys in Office F1. Those shortcuts were to create groups or dissolve groups. The hide and display shortcut is: <Ctrl> <8> Where the "8" is *only* using the key under the function keys, *not* the key in the Num keypad.
Reply With Quote
Reply

  TechArena Community > Technical Support > Computer Help > Office Help > MS Office Support
Tags: , , ,



Thread Tools Search this Thread
Search this Thread:

Advanced Search


Similar Threads for: "Show/Hide group symbols via shortcut in Excel"
Thread Thread Starter Forum Replies Last Post
Does Excel consist Telephone, Fax and Email symbols Holly Dayin MS Office Support 5 25-01-2012 06:53 PM
How to get special symbols for correct sign in Excel Shaina Na Windows Software 1 06-01-2012 05:07 PM
How to add statistics symbols in Excel like y-hat, bar x, etc. Tritanic MS Office Support 2 05-01-2012 05:05 PM
Show AM/PM Symbols in System Tray Clock in Windows 7 Shikhar Tips & Tweaks 3 24-03-2009 09:42 PM
Keyboard shortcut to open/hide the Sidebar? JG2048 Vista Help 2 13-03-2007 09:56 PM


All times are GMT +5.5. The time now is 02:25 PM.