MrExcel Publishing
Your One Stop for Excel Tips & Solutions

cell protection?

Posted by linda childs on July 30, 2001 7:45 PM

I have a huge work sheet that is accessed and updated by numerous employees. I would like to prevent them from entering non-numeric numbers into certain fields. Is there a simple way to do this? I know it can be done using the dialog boxes, but that is too time consuming to redo all the data fields.

Thanks you!

Posted by steve w on July 30, 2001 7:54 PM

Try data validation
steve w

Posted by L.Childs on July 30, 2001 8:01 PM

I'd love to - but I don't know how.

Posted by Aladin Akyurek on July 31, 2001 12:30 AM

Data validation to control the input

Suppose A1 on worksheet X is one of the entry/input cells and is empty.

Activate A1.
Activate the option Data|Validation.
Select Custom for Allow on Settings tab of the Data Validation dialog.
Enter as Formula:


If you so desire, you can include a message via Error Alert tab.

Copy down A1 as far as needed.

Note. If you have more conditions on the numbers to be entered, the above formula can be extended to cover them.