how do i protect cells in excel to prevent users from deleting formulae in my worksheets
L locking cells in excel Jun 14, 2006 #1 how do i protect cells in excel to prevent users from deleting formulae in my worksheets
D Dave Peterson Jun 14, 2006 #2 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.
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 Jun 14, 2006 #3 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
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
