Locking individual cells in an excel spreadsheet

  • Thread starter Thread starter sglassedmkw
  • Start date Start date
S

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!
 
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
 
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
 
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
Click to expand...
Did you do this?


Gord
 
Haha perfect! Thank you so much!

sglass

Gord Dibben said:
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
Click to expand...
 
Back
Top