How do I allow data entry to one column only?

C

Carmen

I've created an order sheet that needs to have all data locked except one
column and one cell.

How do I lock the sheet and allow data entry to the areas I want accessible
without having to create a password for users?
 
G

Gary''s Student

Lock all the cells you want to protect and then protect the worksheet itself.
 
E

Eduardo

Hi,
Highlight what to want the users have access to , right click on the mouse,
format cells, protection, uncheck locked, then protect the worksheet

if this helps please click yes, thanks
 

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