Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel: match two cells in one sheet to two cells in another and return a third cells value | Excel Worksheet Functions | |||
paste locked cells and unlocked cells in protected sheet | Excel Worksheet Functions | |||
conditional formating cells i Excel based on other cells values | Excel Worksheet Functions | |||
trying to create an (almost) circular formula between cells and data validated cells with lists | Excel Worksheet Functions | |||
Pasting single cells from Word to multiple cells in Excel | Excel Worksheet Functions |