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? |
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? |
All times are GMT +1. The time now is 04:44 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com