Forum Discussion
List excel
Hello, I have two questions.
1- I created an independent drop-down list as well as three lists dependent on each other. However, when I experiment with the table, if I change the data of my independent column, the data of the columns that follow does not disappear automatically. I can change the data afterwards but I would like that as soon as a choice of the independent column is made, the data of all the other columns disappear.
2- In the tables that I created, there is several information in the same cell. The information is in text form. In my table, I made spaces so that the information is visible horizontally, here is an example:
Is there a possible function so that when this information is found in a drop-down list, it appears in the same way and not all on the same line?
Thank you!!
- A possible workaround would be utilizing conditional formatting and some clever custom cell formatting to 'blank out' the cells with drop lists selections that don't correspond to each other.
1. This would require VBA code.
2. Turn on Wrap Text for the cells with the data validation dropdown.
