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

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?
 
G

Guest

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
Forcing entry into validation cell 1
How to force entry in cell before saving. 2
how do I block users to save the excel file if conditions not met 1
In Excel I need to insert a clean form each use 1

Top