How To Use Button To Show Or Hide Columns In Excel

How To Use Button To Show Hide Columns In Excel?

Sometimes you need more control over the workbook you are working on. Creating a show/hide button is will give you that control. You can hide numerous columns with a simple click on the button. Isn’t that great?

This tutorial is an advance level tutorial. I will be using toggle button and Excel VBA for this task. Remember, I am using Microsoft Excel 2010 for the demonstration.

Let’s have a look at the step by step tutorial on How To Use Button To Show/Hide Columns In Excel.

Step 1: First you need to add a toggle button. To create a toggle button you’ll have to click on “Developer” tab and then click on “insert” and then click on “Toggle Button”.

Step 2: Draw a Toggle Button inside the workbook you are working on.

Step 3: Now Double click on the button and Paste the code (Please subscribe and here goes the code: patreon.com/posts/34608388)

Step 4: Turn off the “Designer mode” by clicking on the “Developer” and “Design Mode”

Done. You have successfully created a button to show or hide column in excel.

NB:
In the code xAddress = "F:G" here F & G are the column name I want to hide and show.

ToggleButton1.Caption is the place where you need to add the button text.

-------------------------------------------------------------------------------------------------------------
Support Us: patreon.com/excel10tutorial
-------------------------------------------------------------------------------------------------------------

#excel10tutorial #excelbutton

Thanks for watching.

If you like this tutorial, please subscribe to Excel 10 Tutorial:
goo.gl/uL8fqQ

Checkout our Advance Excel Tutorial Playlist:
goo.gl/ExYy7v

Checkout the Excel tutorial for dummies playlist: goo.gl/UDrDcA

Checkout the Excel Case playlist:
goo.gl/xiP3tv

If you need any specific tutorial you can request that here: goo.gl/jM78fA

Connect us on social media

Facebook: goo.gl/hdJ7rN

Google Plus: goo.gl/Yk4DQc *Become a member and enjoy exclusive perks while supporting the channel you love!*
youtube.com/@Excel10tutorial/join