View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
CLR CLR is offline
external usenet poster
 
Posts: 1,998
Default Entering Codes Into a Cell

The feature you seek is called Data Validation. Select the cell(s) you wish
to treat, and then do DATA VALIDATION SETTINGS TAB LIST and then
follow the menus....

Vaya con Dios,
Chuck, CABGx3



"George" wrote:

I have a column where the entries are always going to be one of four or five
codes, for simplicy sake lets say it is A, B, C, D or E. How do I set it up
that if anything else but one of those letters is entered, the cell will not
accept it.