Toggle Visible Items in Excel Using a Button

Quickly toggle worksheet sections on or off - visible or hidden - using a button and a little VBA (Macros).

This tutorial takes you from a regular worksheet through the steps of creating something visually appealing and useful. The goal is to be able to hide any section of a worksheet with the click of a button so that you can better analyze the data that is there in the worksheet.

This method works for hiding text, hiding formulas, hiding charts, hiding tables, hiding pivot tables, and hiding everything else that can go into the worksheet.

If you'd like a non-vba way to do this, you can look at this tutorial: Hide or Toggle Worksheets without VBA