Can I Protect a cell range only?

B

Bruce

I don't want to protect the whole sheet, and then set up exclusion ranges. I
want to protect the C column only.

Is there a way to do that?
 
G

Gord Dibben

Bruce

By default all cells are locked when the sheet is protected.

Hit CRTL + A(twice if xl2003) then Format>Cells>Protection. Uncheck "locked"
and OK.

Select the cells you wish to lock and Format>Cells>Protection. Check "locked"
and OK.

Now Tools>Protection>Protect Sheet. This is mandatory!!

You can set a password to unprotect. These can easily be broken in Excel but
will keep your formulas from being accidentally overwritten.


Gord Dibben Excel MVP

I don't want to protect the whole sheet, and then set up exclusion ranges. I
want to protect the C column only.

Is there a way to do that?
Click to expand...

Gord Dibben MS Excel MVP
 
Top