Locking individual cells in an excel spreadsheet

[sglassedmkw]

I'm looking to lock specific cells in a spreadsheet so that no one can change
them. It needs to be a workable cell because its part of (or linked to) a
formula. I need to be able to change and work with the rest of the spread
sheet. I need someones help!!! Thanks for your help in advance!

 

[Gord Dibben]

Bt default all cells on a protected sheet are locked.

Select all cells using CTRL + a(twice in 2003)

Format>Cells>Protection. Check unlocked.

Select the cells to lock and lock them.

Tools>Protection>Protect Worksheet.

The cells with formulas will be workable but not editable.


Gord Dibben MS Excel MVP

 

[sglassedmkw]

Thank you so much for your response. Unfortunatly, it doesn't seem to be
working for me. Am I maybe missing a step? After I do the initial steps,
and then go Tool>Protection>Protect Worksheet, which of the boxes need to be
checkmarked?
Your help is greatly appreciated.

sglass

 

[Gord Dibben]

Whichever options you would like users to be allowed can be checked.

I prefer not allowing users to select locked cells but they must be allowed
to select unlocked cells.

See more in-line below........

Thank you so much for your response. Unfortunatly, it doesn't seem to be
working for me. Am I maybe missing a step? After I do the initial steps,
and then go Tool>Protection>Protect Worksheet, which of the boxes need to be
checkmarked?
Your help is greatly appreciated.

sglass

Did you do this?


Gord

 

[sglassedmkw]

Haha perfect! Thank you so much!

sglass

Whichever options you would like users to be allowed can be checked.

I prefer not allowing users to select locked cells but they must be allowed
to select unlocked cells.

See more in-line below........


Did you do this?


Gord