Toggle button for hide/unhide columns

excel_user1

New Member
Joined
Jan 15, 2016
Messages
3
Hi, I have a task for my student project in front of me that I need to do.. I have looked in all kind of forums but unfortunately I had no chance finding the solution for my problem..
Being a absolute beginner in Excel I need someone to help me.
I use Excel 2010 and I need to do next task..

I have a table with 8 rows and 10 columns. I have to create a toggle button to show only certain columns.
For example.
If in B2, B5, B9 etc.. says "FINISHED", and in B1, B3,B4,B6 says "NOT FINISHED" I need the toggle buttons that when clicked only shows entire columns with these perimeters...

I wanted to attach the screenshot with my table but I don't not how
so hopefully someone understand what I'm asking...
Thanks
 

Some videos you may like

Excel Facts

Format cells as time
Select range and press Ctrl+Shift+2 to format cells as time. (Shift 2 is the @ sign).

My Aswer Is This

Well-known Member
Joined
Jul 5, 2014
Messages
16,761
Office Version
2013
Platform
Windows
excel_user1

Mr. Excel discourages us from helping students do their assignments.
 

Watch MrExcel Video

Forum statistics

Threads
1,099,082
Messages
5,466,534
Members
406,484
Latest member
kaksolver

This Week's Hot Topics

Top