How to create a searchable drop down list in Excel?.How to create a drop down list calendar in Excel?.How to autocomplete when typing in Excel drop down list?.How to auto populate other cells when selecting values in Excel drop down list?.Press Alt + Q keys simultaneously to exit the Microsoft Visual Basic for Application window.įrom now on, when you select No in the drop down list, all specified columns are hidden.īut if you select Yes in the drop down list, all hidden columns are displayed immediately. Note: In the above code, Column = 2 and Row = 3 is the cell reference of the drop down list, and the range C:I is the columns that you want to hide or unhide. If Target.Column = 2 And Target.Row = 3 ThenĪ = TrueĪ = False VBA code: hide or unhide columns based on drop down list selection Private Sub Worksheet_Change(ByVal Target As Range) Then copy and paste below VBA code into the Code editor. Double click the current open sheet name in the VBAProject section to open the Code editor.Ĥ.

Then press Alt + F11 to open the Microsoft Visual Basic for Application window.ģ.

First, create your drop down list with Yes and No which you need.Ģ. Hide or unhide columns based on drop down list selection in ExcelĪs above example mentioned, to hide or unhide columns C to I based on the drop down list selection, please do as follows.ġ. In this article, we will show you a VBA method to hide or unhide columns based on drop down list selection in Excel. For example, if you select No in the drop down list, column C to I will be hidden, but if you select Yes, the hidden columns C to I will be unhidden. While using Excel, you can hide or unhide specific columns based on the selection of a drop down list. How to hide or unhide columns based on drop down list selection in Excel?

How do i unhide a column in excel 2010