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

by Tom Urtis 4 Comments ↓

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.

‹ Tom’s Tutorials For Excel: Copying Your Page Setup to Multiple Worksheets

Tom’s Tutorials For Excel: Formatting 0 to Look Like “Zero” ›

Posted in Tom's Tutorials for Excel
Tags: Analytics, Big Data, Business Intelligence, Data Science, Excel Expert, Excel Guru, Filter Subtotal Group, Microsoft, Microsoft Excel, Microsoft MVP, Microsoft Office, Tips and Tricks, Tom Urtis

4 comments on “Tom’s Tutorials For Excel: Toggling to Show or Hide Your Group and Outline Buttons”

1. Larry Vance says:

   March 25, 2015 at 7:05 am

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

   Reply
2. John Hackwood says:

   September 13, 2015 at 8:53 pm

   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

   Reply
3. chakravarthy svgk says:

   April 2, 2017 at 11:18 pm

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

   Reply
   • Tom Urtis says:

     April 2, 2017 at 11:46 pm

     Lessons with Excel workbooks and videos will be made for sale later in 2017.

     Reply