How to protect only some selected cells in excel 2007?

T

Thinh

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!
 
G

Gary''s Student

1. unprotect the worksheet
2. unlock all cells
3. select all cells with formulas
4. lock the selected cells
5. protect the worksheet
 
Top