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

T

TexSki

Joined
Jun 29, 2017
Messages
3
Reaction score
0
Hello,

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.

Texski
 

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

Similar Threads

Excel 2013: New row added automatically but first 2 columns Drop down lists not available... 0
VBA-Table Word 2019 - Move a selected text, from a cell to the adjacent cell to its right, by pressing the ENTER key 0
Cumulative formula for word table 0
Closing PDF file from Excel VBA (Adobe Reader, Adobe Acrobat, Browser) 0
How can I get a Shareable URL via VBA code to a OneDrive image? 0
Word 2013 DDE merge to Excel file 0
External cell reference between two excel worksheets both in One Drive 0
How to Create an S-Curve from Custom Field? 0

Top