Hide or Toggle Worksheet Sections without VBA in Excel

Add to Favorites
Author: | Edits: don

Forms Course

Hide/Show Sections of an Excel worksheet with the click of a button with no VBA or macros required.

This trick makes your spreadsheet much easier to use and understand by allowing the user to hide or show parts that are not needed right now, such as a section for data input or reporting or maybe the charts section of a worksheet.

With this trick, you will be able to hide entire sections of rows and columns in different parts of the spreadsheet and reduce clutter so that you can better focus on more important things in the worksheet.

Downloadable Files: Excel File

Question? Ask it in our Excel Forum

Our Excel Courses

  • 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.

  • 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
Activate or Navigate to a Worksheet using Macros VBA in Excel
Tutorial: Make a particular worksheet visible using a macro in Excel. This is called activating a wo...
Toggle Visible Items in Excel Using a Button
Tutorial: Quickly toggle worksheet sections on or off - visible or hidden - using a button and a li...
Remove Dashed Lines from Copy Paste VBA in Excel
Tutorial: How to remove the flashing dashes from a copy/paste range using VBA in Excel; this removes...
Copy and Paste Data using Macro VBA in Excel
Tutorial: How to copy and paste data using a Macro in Excel. I'll show you multiple ways to do this,...
Put Data into a Worksheet using a Macro in Excel
Tutorial: How to input data into cells in a worksheet from a macro. Once you have data in your macro...
Get the Last Row using VBA in Excel
Tutorial: (file used in the video above) How to find the last row of data using a Macro/VBA in Exce...