protect cells in excel to prevent users from deleting formulae

  • Thread starter locking cells in excel
  • Start date
L

locking cells in excel

how do i protect cells in excel to prevent users from deleting formulae in my
worksheets
 
D

Dave Peterson

You can lock or unlock each cell via:
format|cells|protection tab

But the "lockedness" of the cell doesn't mean much until you protect the sheet.
Tools|protection|protect sheet

Be aware that worksheet protection is easily bypassed and there are lots of
things that aren't available on protected sheets.
 
A

Allllen

TWO STEPS

Format > Cells > Protection
Tick 'locked' for the cells you want to be protected
untick it for any cells you don't want protected

Then
Tools > Protection > Protect Sheet
Allow users to select only unlocked cells
Put a password in
 

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

Protecting Word 2019 document 0
Password protect new workbooks from template 0
Protected sheet - attempt to delete row = unmerged cells 5
Protected Excel Worksheet 1
Prevent cut & paste in a protected worksheet. 0
Protect woksheet and keep using outline capabilities 1
hide columns on a protected sheet??? 1
Cell data entering slow! 0

Top