Hi
When using the data validation for a drop down list, I can't remove the blank entries. Is there any solution to this? I searched a few methods but none worked. There are two scenarios:
1. three cells as the source:
non-blank blank blank
2. and one combination cell and one non-blank cell.
please see my attachment for details. I'm using Excel 2007.
Bookmarks