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?
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |