Security - Locking specific cells

  • Thread starter Thread starter Allan
  • Start date Start date
A

Allan

I need to know if it is possible - and if so, then how -
to lock a specific group of cells within a worksheet. I
know how to lock the whole worksheet, but in order for
this to work data entry will be required in some cells,
yet not allowed in others.

For example, say I wanted to lock cloumn B which has a
formula based on data in columns A, C and D; but I want to
allow columns A, C, and D to be able to be altered. How
can I lock just column B so no one else can alter the data
or formula?

Any help is greatly appreciated. Thanks!
 
Allan said:
I need to know if it is possible - and if so, then how -
to lock a specific group of cells within a worksheet. I
know how to lock the whole worksheet, but in order for
this to work data entry will be required in some cells,
yet not allowed in others.

For example, say I wanted to lock cloumn B which has a
formula based on data in columns A, C and D; but I want to
allow columns A, C, and D to be able to be altered. How
can I lock just column B so no one else can alter the data
or formula?

Any help is greatly appreciated. Thanks!
Click to expand...

Select the whole worksheet.
Format > Cells > Protection tab, uncheck "Locked".
Then select column B.
Format > Cells > Protection tab, check "Locked".
Protect worksheet in normal way.
 
Back
Top