How to auto hide and unhide columns using 1 and 2 icons

[R. Rebello]

While working on a worksheet some of the columns set into auto hide and
unhide mode. Columns can be hidden or unhidden through 1 and 2 icons.
Please explain the procedure to set such functions.

 

[David D]

You should be able to record macros that will hide (or unhide) the currently
selected column. Then you can create icons for your new macros and place
them on your toolbar.

If you're looking for something more automated, that hides columns based on
some values, you'll have to create a more complex macro that evaluates each
column in the active sheet and then hides it (or not). If you could tell me
more about what you're doing, perhaps post your file, I could probably help.