Hi All

I can't believe this question hasn't been asked before, yet I can't find anything for Googling or in previous posts.
If anyone would know the answer though, it's the people in this great forum

I'm trying to find out if there's a way to use data validation to reference a range of cells for a dropdown list, whilst also disallowing the user to leave the cell blank

So I have this dropdown list setup. But it's essential a report frequency is always selected.
How can I stop the user from deleting the cell contents and leaving it blank?

Picture1.png

Any advice welcome
All the best
Vicky