Tom’s Tutorials For Excel: Toggling to Show or Hide Your Group and Outline Buttons
When you have a worksheet with rows and/or columns that have been grouped…
…you can press your keyboard’s Ctrl+8
keys…
…to quickly and easily toggle to show or hide your Group and Outline buttons.
Love this tip. This will be as helpful to me as the F4 tip.
Thanks so much Tom I never knew you could ‘hide’ the outline…
The VBA for turning off and turning back on again is this:
ActiveWindow.DisplayOutline = False
ActiveWindow.DisplayOutline = True
pls provide respective sample excel for each post. will become easier for someone new to learn
Lessons with Excel workbooks and videos will be made for sale later in 2017.