Protecting formula in cells

  • Thread starter Thread starter BB
  • Start date Start date
B

BB

I am not going to be using this spreadsheet myself, so how
would I go about protecting a cell with a formula in it?.
I don't want anyone typing over the formula, because the
people who are going to use this spreadsheet don't know
anything about how to repair the formulas. Please help.
 
BB

By default all cells on a worksheet are "locked for editing" when
Tools>Protection>Protect Sheet is enabled.

To "lock" just some cells......

CRTL + A to select all cells.

Format>Cells>Protection. Uncheck "locked".

Select your specific cells on the worksheet and Format>Cells>Protection.
Checkmark "locked".

Now Protect the Worksheet.

Gord Dibben Excel MVP
 
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

Cell shows the last typed text, no matter where it is typed 0
#N/A In Cells 7
HELP!!!!!!!!! 2
Protect formulas which reference to unlocked cells in protected s. 5
protecting certain cells in Ecxel 2007 2
Cell Protection 2
Remove link to formula source 1
How do I protect cells or a range of cells in excel spreadsheet? 1

Back
Top