Excel 2013: How to ensure a cell is not left blank by users? (Not using VBA)

Jun 29, 2017
Reaction score

Looking to know if it is possible, not using VBA, to ensure a cell is not left in a blank state by a user during data entry, and if it is possible how to.
Data validation via a list does not appear to work - cell can be left blank if user does not choose a value or tabs past the cell.
Is it possible by using IF function?

Thanks for any help.


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question