Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
I have a worksheet that has several cells that need to be protected (locked)
from changes. How do I lock only those cells without locking the whole worksheet? |
#2
![]() |
|||
|
|||
![]()
Hi
select the whole worksheet (or the bits you want people to get to) then choose format / cells / protection and untick locked ... now if you unlocked all cells, you'ld need to lock the ones that you don't want them to get to. once you've locked and unlocked the appropriate cells, choose tools / protection / protect sheet. Cheers JulieD "Evelyne" wrote in message ... I have a worksheet that has several cells that need to be protected (locked) from changes. How do I lock only those cells without locking the whole worksheet? |
#3
![]() |
|||
|
|||
![]()
Evelyne
By default all cells are locked when the sheet is protected. Hit CRTL + A(twice if xl2003) then FormatCellsProtection. Uncheck "locked" and OK. Select the cells you wish to lock and FormatCellsProtection. Check "locked" and OK. Now ToolsProtectionProtect Sheet. This is mandatory!! Gord Dibben Excel MVP On Thu, 31 Mar 2005 16:11:02 -0800, "Evelyne" wrote: I have a worksheet that has several cells that need to be protected (locked) from changes. How do I lock only those cells without locking the whole worksheet? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Alignment of Multiple-Level Category Labels Not Possible? | Charts and Charting in Excel | |||
Print all records labels | Excel Discussion (Misc queries) | |||
labels in formulas | New Users to Excel | |||
Y axis labels | Charts and Charting in Excel | |||
Chart disappears when source data cells are hidden | Excel Discussion (Misc queries) |