R
Ricky
Hello Experts,
I've checked the "Ignore Blanks" checkbox within Data Validation and all
blank cells are unlisted within the Dropdown list. However, when I copy and
paste as values (that does include blank cells) to replace the Source range,
the Ignore Blanks feature doesn't work anymore. I see a list of blank cells
within the bottom of my dropdown list. What is the workaround to maintain a
dropdown selection list that continues to ignore blanks?
Thanks in advance,
Ricky
I've checked the "Ignore Blanks" checkbox within Data Validation and all
blank cells are unlisted within the Dropdown list. However, when I copy and
paste as values (that does include blank cells) to replace the Source range,
the Ignore Blanks feature doesn't work anymore. I see a list of blank cells
within the bottom of my dropdown list. What is the workaround to maintain a
dropdown selection list that continues to ignore blanks?
Thanks in advance,
Ricky