Forum Discussion
Angie Swirski
Jul 02, 2018Copper Contributor
Turning Colums on and off to comare
Hello I have been scouring all over to figure this out - I believe Excel can do it but just not sure how. I've tried a few things and nothing has worked. Following is a link to exactly I'd like to c...
SergeiBaklan
Jul 03, 2018Diamond Contributor
Matt, it looks like this
With checkboxes you hide/unhide table columns.
Matt Mickle
Jul 03, 2018Bronze Contributor
Sergei-
Thanks for relaying the screenshot.
Angie-
I didn't immediately think of the easiest solution because I figured this was not what you were looking for... but you can also:
1. Select an Entire Column or Row
2. Right Click
3. Hide / Unhide
If the code is more preferable it should be easy to adjust if you wanted to only toggle certain columns or rows visibility on or off. If you provide the specifics I would be happy to alter it accordingly. It can also be modified to work like the website. i.e. checking a box toggles a specific column on or off.
- SergeiBaklanJul 03, 2018Diamond Contributor
Perhaps like this https://excel.tips.net/T003283_Hiding_Columns_Based_on_a_Cell_Value.html