MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Restricting possible values entered in cells


Posted by Conor Davies on October 30, 2001 9:18 AM

Hi (again),
I'd like to limit the possible values that a user can enter into a cell (or a whole range of cells).
I only wish to allow the numbers 1,2,3 or 4. If they enter anything else they need to be prompted to enter an acceptable value.
Can this be done?
Can each cell have some kind of drop-down menu that allows a choice from only the numbers I want? (Like a drop-down menu you get on web pages, questionnaires etc.)

Many thanks in advance.
Conor Davies


Posted by Barrie Davidson on October 30, 2001 9:36 AM

Yes, this can be done using Data Validation. See Excel's help to use this function. If you need any help, just let me know via this board.

Regards,
BarrieBarrie Davidson

Posted by Conor Davies on October 30, 2001 10:02 AM

Thanks, Barrie... how about my other problem , posted at the same time as this one...
"Naming individual data points" ?
Many thanks
Conor Davies

Posted by Barrie Davidson on October 30, 2001 10:07 AM

Sorry, graphing is not my strong suit (nt)