Protecting formula in cells

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

Gord Dibben

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
 

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

Copy addition formula of non-consecutive horizontal cells 2
Is there a function to count how many times a cells value is used? 0
Excel does not accept text format! 0
Dealing with a Pivot Table (when I don't want to) 0
Integrating information from Word to Excel (not mail merge) 1
Office365 Family + TXT or MX Domain 0
Insert/ delete row in protected worksheet 6
Display weeks from a Milestone 0

Top