Drop Down plus any entry

B

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?
 
O

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
 
T

tjtjjtjt

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

tj
 
B

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.
 
Top