Results 1 to 3 of 3

Thread: Show/Hide group symbols via shortcut in Excel

  1. #1
    Join Date
    Oct 2011
    Posts
    120

    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.

  2. #2
    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.

  3. #3
    Join Date
    Aug 2011
    Posts
    695

    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.

Similar Threads

  1. Does Excel consist Telephone, Fax and Email symbols
    By Holly Dayin in forum MS Office Support
    Replies: 5
    Last Post: 25-01-2012, 07:53 PM
  2. How to get special symbols for correct sign in Excel
    By Shaina Na in forum Windows Software
    Replies: 1
    Last Post: 06-01-2012, 06:07 PM
  3. Replies: 2
    Last Post: 05-01-2012, 06:05 PM
  4. Show AM/PM Symbols in System Tray Clock in Windows 7
    By Shikhar in forum Tips & Tweaks
    Replies: 3
    Last Post: 24-03-2009, 09:42 PM
  5. Keyboard shortcut to open/hide the Sidebar?
    By JG2048 in forum Vista Help
    Replies: 2
    Last Post: 13-03-2007, 09:56 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Page generated in 1,711,654,378.40985 seconds with 17 queries