Auto hide and unhide of columns based on a cell value

Dear forum,

Good evening everyone. I want to learn auto hide and unhide of columns based on value contains a cell. I do not prefer macro.

I have a worksheet, which has 97 column. while doing data entry, its really difficult to focus and do entry. I would like to know that, is there any option like, If i will enter an any value in A column then only B column should be opened.

Kindly guide and help me.

Thanks in advance

Bala

You won't be able to do that with a formula.

Pete

Hello Mr. Pete,

Thanks for your response. Is there any other way to do that, if formula wont to do. If macro. How to do that?

Thanks

Bala

If it were me, I would probably manually hide the columns that had formulae in, so that only those that require data input are visible. Then you can unhide them all when you are finished entering data.

Hope this helps.

Pete