Drop Down plus any entry

[Brenda Rueter]

User wants a drop-down list for common entries but also the ability to enter
anything into a cell. I thought Data Validation would do the trick, but I
don't see how to get the common entries to drop down AS WELL AS the ability
to enter by hand. Can someone point me in the right direction please?

 

[Otto Moehrbach]

Brenda
Select your cell.
Click on Data - Validation
In the "Allow:" box, select "List"
In the "Source" box, type in your common values, such as
Common1,Common2,Common3. Don't put a space between them.
Select the Error Alert tab
Uncheck the "Show error alert after invalid data is entered" box
Whenever that cell is selected, a drop-down arrow will be displayed on the
right of the cell.
Click on that arrow and the list will drop down
You can also enter anything you want without creating an error.
HTH Otto

 

[Guest]

You could uncheck the Show error alert after invalid data is entered.
Data | Validation | Error Alert. Uncheck the box mentioned above.

tj

 

[Brenda Rueter]

Thank you Otto. That method works very well and was new to me.

 

[Brenda Rueter]

Thank you (whoever you are) as that method ALSO worked well. It was a
concept I've thought about but never needed to use before now.