protect worksheet but allow users to use specific columns/cells

  • Thread starter Thread starter mexpedip
  • Start date Start date
M

mexpedip

how do I protect the worksheet but allow users to change the values in
specific column/cells? Specifically, I want to protect a worksheet so
changes can't be made to anything but the "quantity" column. Thanks in
advance for the help.
 
Hi,
Select the cells you want the users to have access, then right click in the
mouse, cell format, go to the last tab = Protection and uncheck locked, then
protect your worksheet and done

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

Similar Threads

Sheet Protection 3
Protected worksheet allow users 1
Password Protect Specific Range Of Cells 6
Cell Protection? 2
Allowing row deletion in worksheet with locked cells 2
hide columns on a protected sheet??? 1
Edit text format in non-protected cells in protected worksheet 1
hide, unhide column or row after protect worksheet 4

Back
Top