• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 531
  • Last Modified:

Picklist in Excel 2010

I have a pick list in excel 2010 but I also need to be able to allow folks to enter unique data if one of the options does not pertain to them how can I have a picklist that allow user input?
0
jlcannon
Asked:
jlcannon
1 Solution
 
NBVCCommented:
Do you mean Data Validation List?

If so, go to the Data Validation for that cell, and in the Error Alert tab, uncheck the checkbox at the top "show error alert after invalid data is entered"
0

Featured Post

Visualize your virtual and backup environments

Create well-organized and polished visualizations of your virtual and backup environments when planning VMware vSphere, Microsoft Hyper-V or Veeam deployments. It helps you to gain better visibility and valuable business insights.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now