Menu
Fix: Turn Off Ignore Blank Select the cell that contains a data validation list. Choose Data|Validation. On the Settings tab, remove the check mark from the Ignore blank box. Click OK.
For example you have below data in a range B2:B13, for creating drop down list without blank cells, first, you can copy and paste the data into a new column without blanks. And then create a drop down list based on this new value list.
After adding data validation to the cell with 'list of items' I've stuck to add 'empty value' to the list of valid items.
By for selecting 'empty value' I expect to clear the cell.
Is that possible?
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With