text validation

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How can i accomplish, that I only have a few options (text) to enter in a cel
Not a dropdownlist, because it are e few thousend cells
It's a sort of validation of text

Thanks a lot
 
Hi Taco
why don't you use data validation ('Data - Validation').. Try the
following:
- select all your cells -the few thousands :-)
- goto data validation and choose your list for valid entries

Frank
 
Taco

If you don't want drop-down list arrow in every cell, use Frank's method but
uncheck "in-cell dropdown".

Note: in the "list" dialog box you can enter your valid text using a comma
between each entry. That's if you don't have a handy range of the text values
to point to.

e.g. cat,dog,horse,warthog

Gord Dibben Excel MVP
 
Back
Top