creating Yes,No
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.
|