•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
How to get rid of blank space in excel dropdown
Hello,
I created a dropdown for data that needs to be filled in on another sheet. Since that data is blank until filled in, the dropdown shows this blank space. I'm not sure if it's red because of my appearance settings or something but I'd like to get rid of this blank part. The "ignore blanks" setting doesn't do anything and like I said, the data needs to be filled in by the user.
Thank you
[link] [comments]
Want to read more?
Check out the full article on the original site