Help with Drop Down formatting

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

Guest

Can a cell that has been programed with a drop down list be set to allow
something tobe free texted in the cell that is not in the drop down list?
 
In the data validation dialog box, select the Error Alert tab
Remove the check mark from 'Show error alert after invalid data is entered'
 
Hi Gord
$§$%& copy + paste
I think Debra already has provided the correct link :-)
 
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

Filtered drop down list 2
Data Validation List (Drop Down) Not Showing 2
Excel Formatting in Drop Down Lists 2
Combining two non-contiguous lists into one for data validation, with one range being dynamic 0
Filter a Drop List ? 1
Change drop down list in one cell based on values in other cells 2
Excel Excel: How do I put a formula in a drop down list 11
Data validation list using filtered range 3

Back
Top