Thread: cells
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
bigwheel bigwheel is offline
external usenet poster
 
Posts: 222
Default 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