| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
How do I force a user to fill in all cells in excel before saving
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? |
|
#2
|
|||
|
|||
|
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. "tomtomtomtomtom" wrote: 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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Force entry to one of three cells | Excel Worksheet Functions | |||
| How do I force Excel to use fixed cells on a different worksheet? | New Users to Excel | |||
| Sum cells according to colour fill | Excel Discussion (Misc queries) | |||
| Identifying the Active Fill Color | Excel Discussion (Misc queries) | |||
| copy group of cells to another group of cells using "IF" in third | Excel Worksheet Functions | |||
Hybrid Mode
