maintain data from drop down menus

S

ScottWW

I have created an Excel (2007) form for workers to use where some columns
have drop down menus. Many people are cutting and pasting from an older,
similar version of the form (still 2007) which doesn't contain the same
options as in the new drop down menu. I would like to know how to "lock" the
cell to where the people cannot simply cut and paste other data and input
that data into those cells. Thank you in advance for your help.
 

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

Top