#1
|
|||
|
|||
Protect formula in cell?
Office XP
My goal is to protect cells of a spreadsheet that hold formulas so as to not inadvertently overwrite same with data. Help is not helpful. I'm finding how to protect an entire sheet and then allow exclusions or... The nearest I find is???
|
#2
|
|||
|
|||
Two things have to be in place to protect a cell... The cell must be locked and then sheet protection must be turned on.
Worksheet cells are locked by default, so you need to unlock the ones that don't have formulas. You can select the entire worksheet and unlock them and then select the cells that contain formulas and lock them back. (Or you can Find & Select Constants and unlock them, but this won't unlock empty cells.) To Unlock or Lock, go to the Format Cells and on the Protection tab, uncheck (or check) Locked. Now when you protect the sheet, only the cells that are "locked" are protected from being edited. To protect the sheet, right-click on the worksheet tab and choose protect Sheet. check any boxes that you want users to be allowed to do. There is no need to set a password unless you are concerned about malice. Click OK. |
#3
|
|||
|
|||
Very clear explanation Kimberly, but one question before I get started.
You say that by default a spreadsheet's cells are all locked. Dumb question. If all cells are locked, then how can anyone (including me) open a brand new sheet and enter anything in any cell? Doesn't 'locked' mean keep out? |
#4
|
|||
|
|||
It is like having all the doors to your house locked but not shut. Locked or unlocked... doesn't matter, everyone can walk right in.
Turning on sheet protection is like shutting all the doors at the same time, and once the doors are shut, people can only walk in through doors that are unlocked. |
#5
|
|||
|
|||
You should be a school teacher :-)!
Thanks. Mark |
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Moving formula range multiple cells when moving sum over one cell | FraserKitchell | Excel | 4 | 02-26-2010 10:38 AM |
Protect signature image in word document | carolind | Drawing and Graphics | 0 | 02-16-2010 06:50 PM |
password protect excel file? | Dawg751 | Excel | 2 | 01-28-2010 06:23 AM |
Help for formula | dehann | Excel | 5 | 05-01-2009 10:44 AM |
Auto-populate an MS Word table cell with text from a diff cell? | dreamrthts | Word Tables | 0 | 03-20-2009 01:49 PM |