Toggle Visible Items in Excel Using a Button

Add to Favorites
Author: | Edits: don

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

Question? Ask it in our Excel Forum


Downloadable Files: Excel File

Our Excel Courses

Professional Input Forms in Excel

  • Skill Level: All Levels
  • |
  • 5 hours+

How to make a fully featured professional form in Excel that is unbreakable. This includes how to use the form to store, view, edit, and delete data from a data storage worksheet.

Send Emails from Excel

  • Skill Level: All Levels
  • |
  • 2 hours

Send Emails from Excel using VBA and Macros. This course starts from the Basics and builds up to more advanced examples with attaching workbooks, worksheets, PDF's, automatically sending emails, including a signature, error handling, increasing speed, and more.

Similar Content on TeachExcel
Email List of People from Excel Using a Macro
: Send Emails from Excel Course Send emails to everyone in a list in Excel using a macro. Th...
Filter Data to Show the Top X Number of Items in Excel - AutoFilter
Macro: This Excel macro filters a data set to display only the top X number of items in that data...
Filter Data to Show the Bottom X Number of Items in Excel - AutoFilter
Macro: This free Excel macro filters a data set to show the bottom X number of items from that da...
Filter Data to Show Only the Bottom 10 Items in Excel - AutoFilter
Macro: This Excel macro filters a selection of data in order to display only the bottom 10 items ...
Use a Form to Enter Data into a Table in Excel
Tutorial: You can enter data into a table in Excel using a form; here I'll show you how to do that....
Select Cells in Excel using Macros and VBA
Tutorial: This is actually a very easy thing to do and only requires a couple lines of code. Below I...