Hello Wounderful XLers,
How may I add a blanck cell so that the user can choose to fill a cell with a blanck ranther than force them to pick a value?
I have several cells with data validation applied, and the data validation is based on a list source in a worksheet called "Lists". I have 4 options that the user can pick from, but now they say they need a blanck as the 5th opption.
I tried to make the first cell in the list in the worksheet "Lists" be an empty cell it did not work. I placed a single space in the first cell, it did not work.
I even unchecked the Ignore blancls in the data validation settings dialog, and it did not work?!
What is the workaround tp make this happen?
Thanks for your advice in advance.
How may I add a blanck cell so that the user can choose to fill a cell with a blanck ranther than force them to pick a value?
I have several cells with data validation applied, and the data validation is based on a list source in a worksheet called "Lists". I have 4 options that the user can pick from, but now they say they need a blanck as the 5th opption.
I tried to make the first cell in the list in the worksheet "Lists" be an empty cell it did not work. I placed a single space in the first cell, it did not work.
I even unchecked the Ignore blancls in the data validation settings dialog, and it did not work?!
What is the workaround tp make this happen?
Thanks for your advice in advance.
Last edited: