List data

  • Thread starter Thread starter Big Rob
  • Start date Start date
B

Big Rob

Can I have a drop down list that, I can either choose from or input something
different?
 
Yes.

Watch this 5 min video:

How to setup a data validation drop down list:


That'll show how to setup the list for selecting items. To be able to
*enter* items not on the list, after you have the basic list set select the
Error Alert tab and uncheck: Show error alert after invalid data is entered.
Then OK.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Drop-down list with Lookup function? 2
How to create 2 dependent drop down lists from 1 original drop dow 5
Filtered drop down list 2
Data Validation: Lists 5
Conditional Data Validation 1
Dependant drop-down lists allowing invalid entries 3
How to force cell input from a List? 3
Create Drop Down Box populated by a List 1

Back
Top