How to protect only some selected cells in excel 2007?

  • Thread starter Thread starter Thinh
  • Start date Start date
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!
 
1. unprotect the worksheet
2. unlock all cells
3. select all cells with formulas
4. lock the selected cells
5. protect the worksheet
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to synchronize all cell values? 1
Protecting cell formulas in excel 2007 1
One Click = Multiple Cells in Excel 2007 2
How To Have A Cell Be Blank If... 2
Data visible in formula bar, but not in cells 1
error selecting cells -excel 2007 4
Function to determine if a cell contains a formula 5
CONVERTING Excel 2003 Commands to 2007 10

Back
Top