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

Discussion in 'Excel' started by TexSki, Oct 2, 2018.

  1. TexSki

    TexSki

    Joined:
    Jun 29, 2017
    Messages:
    3
    Likes Received:
    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
     
    TexSki, Oct 2, 2018
    #1
    1. Advertisements

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 (here). After that, you can post your question and our members will help you out.