Tom’s Tutorials For Excel: Toggling to Show or Hide Your Group and Outline Buttons

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.

Share Button
Posted in Tom's Tutorials for Excel
Tags: , , , , , , , , , , , ,
4 comments on “Tom’s Tutorials For Excel: Toggling to Show or Hide Your Group and Outline Buttons
  1. Larry Vance says:

    Love this tip. This will be as helpful to me as the F4 tip.

  2. John Hackwood says:

    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

  3. chakravarthy svgk says:

    pls provide respective sample excel for each post. will become easier for someone new to learn

Leave a Reply

Your email address will not be published. Required fields are marked *

*