How can I protect certain columns on a sheet so that formulas are.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How do I go about protecting certain columns on an excel sheet so that
formulas are not changed by someone else entering data onto the worksheet
 
Right click on the cells you want to allow data entry in. Then select
"format cells", Then "protection". uncheck the "locked" box. Then protect
the worksheet.
 
You must log in or register to reply here.

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

hide columns on a protected sheet??? 1
protecting formulas without protecting sheet so grouping still wor 1
Protect Only Certain Cells 2
Protecting a Sheet 7
hide, unhide column or row after protect worksheet 4
Formula Audit mode active in one column only; cannot kill. 2
protection and changing formulas 3
sheet and workbook protection 1

Back
Top