How to protect a single cell in worksheet.

[Guest]

I want to protect a cell (e.g. C5) after entering a formula (e.g. C5=C3+C4). But at the same time the entire worksheet except C5 should be unprotected/open for edit.

Kindly suggest solution.

 

[JulieD]

Hi Ashok

when you say "entire spreadsheet" do you mean all 256 columns & 65536 rows
or a smaller area?
also do you want the protection to come on automatically when you enter the
formula in that cell or are you going to enter the formula now and put
protection on that cell as a once off type thing?
which version of excel are you using?

Cheers
JulieD

I want to protect a cell (e.g. C5) after entering a formula (e.g.

C5=C3+C4). But at the same time the entire worksheet except C5 should be
unprotected/open for edit.

 

[Norman Harker]

Hi Ashok!

This was the reply I gave you yesterday:

Excel applies worksheet protection in two stages:

1. Format > Cells > Protection determines which cells are to be
protected and which are to be left unprotected
2. Tools > Protection > Protect Workbook which imposes the protection.

By default, unless you make changes in step 1, all cells are
protected.

So:
Select all cells in the sheet [press button at junction of column and
row headings
Format > Cells > Protection
Remove check from "Locked"
OK
Select the cells that you want to protect
Format > Cells > Protection
Place check in "Locked"
OK
Tools > Protection > Protect Sheet
Give and confirm a password [optional]
OK


But note that worksheet protection is very easily circumvented by
freely available workbooks designed just for that purpose.