Excel hide column formula [Closed]

Report
-
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
-
Hello,

I'm trying to find a way to hide a colum in my excel workbook when I would select one of 3 drop down menu items.

The drop down list is located on top of my sheet1 and give the possibility to see my data either in infos, détails or contact

My sheet1 contains info, detials and contact data and I would just like it if I choose contact that infos and détails rows ( that I would have identified) would hide.

Thanks a lot !




1 reply

Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
767
I may have not understood your question correctly but it seems that you can use a macro to do some thing like this

columns(2).hidden=true

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!