| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Protected cell
Is it possible to protect just some cells and not the entire book?
JPG |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Protected cell
By default all cells are protected but that only becomes active if you
protect the sheet. So to do what you want select all the cells on a sheet then Format|Cells|protection Remove the locked checkmark Then select the cells you want to lock and repeat the above steps but insert the locked checkmark Protect the sheet and your done. Mike "juanpablo" wrote: Is it possible to protect just some cells and not the entire book? JPG |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Protected cell
That doesnt work, because it does not allow me to use the pivot table.
I have pivots that I want to be able to use, but two rows below the table need to be protected. JPG "Mike H" wrote: By default all cells are protected but that only becomes active if you protect the sheet. So to do what you want select all the cells on a sheet then Format|Cells|protection Remove the locked checkmark Then select the cells you want to lock and repeat the above steps but insert the locked checkmark Protect the sheet and your done. Mike "juanpablo" wrote: Is it possible to protect just some cells and not the entire book? JPG |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Protected Cell | Excel Discussion (Misc queries) | |||
| How do I dictate cell to cell progression in a protected worksheet | Excel Worksheet Functions | |||
| How do I format a cell that isn't protected? HELP! | Setting up and Configuration of Excel | |||
| Need to add cell comments in unlocked cell on protected worksheet | Excel Discussion (Misc queries) | |||
| Protected Cell | Excel Worksheet Functions | |||
Linear Mode
