| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to protect only some selected cells in excel 2007?
I only want to block some certain cells (with formula in those cells) in
Excel 2007. Please help share some your ideas how to do it. Thanks a lot! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to protect only some selected cells in excel 2007?
1. unprotect the worksheet
2. unlock all cells 3. select all cells with formulas 4. lock the selected cells 5. protect the worksheet -- Gary''s Student - gsnu200793 "Thinh" wrote: I only want to block some certain cells (with formula in those cells) in Excel 2007. Please help share some your ideas how to do it. Thanks a lot! |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to protect only some selected cells in excel 2007?
Hi Gary''s Student.
It works! Thanks a lot, man! "Gary''s Student" wrote: 1. unprotect the worksheet 2. unlock all cells 3. select all cells with formulas 4. lock the selected cells 5. protect the worksheet -- Gary''s Student - gsnu200793 "Thinh" wrote: I only want to block some certain cells (with formula in those cells) in Excel 2007. Please help share some your ideas how to do it. Thanks a lot! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to improve selected cells shading in excel 2007 | Excel Discussion (Misc queries) | |||
| Protect selected cells without protecting worksheet | Excel Discussion (Misc queries) | |||
| Selected cells in Excel 2007 are not highlighted | Excel Discussion (Misc queries) | |||
| How do I protect selected cells on my worksheet? | Setting up and Configuration of Excel | |||
| How do I protect selected cells on my worksheet? | Setting up and Configuration of Excel | |||
Linear Mode
