Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Lock Cells
I was wondering if someone could help me...I was wondering if there was any
way to lock a couple of cells so that the information cannot be erased, only modified when needed? |
#2
|
|||
|
|||
First, make sure all cells are unlocked... Format-Cells-Protection and
unselect 'Locked' Second, select only the cells you want to lock and Format-Cells-Protection again, this time make sure 'Locked' is checked (for these cells). Third, Tools-Protection-'Protect Sheet' The first step will make sure only the cells you don't want changed remain locked, while the other cells remain editable. -- Regards, Dave "Diana" wrote: I was wondering if someone could help me...I was wondering if there was any way to lock a couple of cells so that the information cannot be erased, only modified when needed? |
#3
|
|||
|
|||
Hi, Dave:
I believe the OP said she wanted to be able to change the data in these cells but not clear (erase) them. If that's the case, Data/Validation may fill the fill. There you can disallow blanks. On Mon, 26 Sep 2005 10:12:11 -0700, "David Billigmeier" wrote: First, make sure all cells are unlocked... Format-Cells-Protection and unselect 'Locked' Second, select only the cells you want to lock and Format-Cells-Protection again, this time make sure 'Locked' is checked (for these cells). Third, Tools-Protection-'Protect Sheet' The first step will make sure only the cells you don't want changed remain locked, while the other cells remain editable. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Order of selecting unprotected cells | Excel Discussion (Misc queries) | |||
Select Range of Cells | Excel Discussion (Misc queries) | |||
Fill cells from non-adjacent cells | Excel Discussion (Misc queries) | |||
Can I use the grouping and lock and protect cells | Excel Discussion (Misc queries) | |||
Convert data type of cells to Text,Number,Date and Time | Excel Worksheet Functions |