Another one using data validaion

Select the range of cells where you want to restrict the input.
Goto the menu DataValidation
Allow: List
As the Source, type in the allowable entries separated by a comma:

Yes,No,Tardy,Absent

Uncheck: In-cell dropdown
OK

--
Biff
Microsoft Excel MVP


"Amin" wrote in message
...
i have a column on my sheet and i have been asked to confine entries to
that
column as yes or no, it could also be tardy or absent, any idea of how am
to
do this.