cells

S

seabeesweetie

Hello everyone...

I just have a quick question. I am using Excel 2003. I have a row of
cells, and I only want someone to be able to fill in (let's say) the number
5. Is there a way to "lock" the cell so they can't put another number in the
cell?

All help is greatly appreciated.

Very Respectfully,
Seabee Sweetie
 
B

bigwheel

Click on Data>Validation the complete the dialog to Allow - whole number,
Data - equal to, Value - 5 then click OK
 
Top