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


Downloadable Files: Excel File

Question? Ask it in our Excel Forum


Excel VBA Course

(35% Sale Ends Jan. 26)

Excel VBA Course - From Beginner to Expert

200+ Video Lessons 50+ Hours of Instruction 200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course (35% Discount)

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...
Tutorial Details
Downloadable Files: Excel File
Excel VBA Course

(35% Sale Ends Jan. 26)

Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course (35% Discount)