Toggle show / hide group outline symbols with shortcut

[Ted M H]

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?

 

[Ragdyer]

Select rows or columns, then:

<Shift> <Alt> <RightArrow>
to display symbols.

<Shift> <Alt> <LeftArrow>
to hide symbols.

 

[Norman Jones]

Hi Ted,

Try:

CTRL+8

See also:

Excel shortcut and function keys


in Excel 2007 help'

 

[Ragdyer]

SORRY !

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.

 

[Ted M H]

Well call me stupid! I really looked--a couple times! Must have been some
sort of blind spot. Thanks so much for a gracious response.

 

[Ted M H]

Thanks for the response. I tried these key sequences out. It appears that
these actual create and remove the groups rather than just hiding and showing
the symbols. This is also helpful to me. Thanks.