When creating a dropdown list using DATA/Data Validation, the 'comma/single quote/comma' creates a blank line at the end of the list. In other words if I don't want any items in the list to appear, this creats and empty cell. I have added a bit more explanation in the previous post.
|