cells
 

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

cells
 

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

"seabeesweetie" wrote:

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

cells
 

Data Validation.
--
David Biddulph

"seabeesweetie" wrote in message
...
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