How do I force a user to fill in all cells in excel before saving

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a form that I have clients fill out. I would like to force them to
fill in all cels before saving and sending the form. Is this possible?
 
If you need the clients to fill the cell with specific data than you can go
to Data Validation. You will first need to create a list with all the codes
that you will allow the client to use. You can create this list on a seperate
sheet or on the same sheet. Hi9ghlight the cell(s) that you want to edit,
then go to DATA - VALIDATION. In the SETTINGS tab, chose "list", it will ask
you to highlight your list. Once done, the cell will have a dropdown menu
with your list of codes.
 

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

how do i force users to first enter data in one cell before anythi 2
Stop user from saving workbook unless cell is filled in 3
Series fill only copying and fill series greyed out 1
linking between worksheets 1
How to force entry in cell before saving. 2
In Excel I need to insert a clean form each use 1
Create Fillable PDF Forms With LibreOffice Writer 3
How do I fill a Cell with a symbol 1

Back
Top