Home

Select specific cells for data validation

%3CLINGO-SUB%20id%3D%22lingo-sub-720337%22%20slang%3D%22en-US%22%3ESelect%20specific%20cells%20for%20data%20validation%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-720337%22%20slang%3D%22en-US%22%3E%3CP%3EIs%20there%20a%20way%20to%20select%20specific%20cells%20from%20a%20list%20that%20only%20show%20within%20a%20data%20validation%20set%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EFor%20example%3A%26nbsp%3B%20I%20have%20a%20list%20of%20fruits%20(Apple%2C%20Pears%2C%20Grape%2C%20Banana)%2C%20but%20for%20this%20data%20validation%20I%20(the%20user)%20only%20want%20to%20show%20Apple%20and%20Grape%20so%20checkbox%20them%20so%20these%20are%20the%20only%202%20fruits%20that%20appear%20in%20the%20drop%20down%20list%20in%20the%202nd%20tab.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EObviously%20the%20earliest%20option%20is%20to%20just%20delete%20the%20fruits%20I%20don't%20want%20in%20the%20list%20but%20I%20want%20the%20list%20to%20stay%20the%20same%2C%20so%20it%20can%20be%20reused%20time%20and%20time%20again%20without%20having%20to%20reproduce%20the%20list.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20attached%20an%20example%20sheet%20with%20the%20contents%20that%20I%20am%20looking%20to%20use.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-720337%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3Edata%20validation%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-722193%22%20slang%3D%22en-US%22%3ERe%3A%20Select%20specific%20cells%20for%20data%20validation%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-722193%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F366456%22%20target%3D%22_blank%22%3E%40Carlos2750%3C%2FA%3E%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EYou%20could%20try%20using%20a%20Dependent%20Drop%20Down%20List%20to%20do%20this.%20There%20is%20a%20blog%20post%20on%20Trump%20Excel%20(%3CA%20href%3D%22https%3A%2F%2Ftrumpexcel.com%2Fdependent-drop-down-list-in-excel%2F%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Ftrumpexcel.com%2Fdependent-drop-down-list-in-excel%2F%3C%2FA%3E)%20that%20explains%20how%20to%20do%20this.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20hope%20this%20helps!%3C%2FP%3E%3C%2FLINGO-BODY%3E
Carlos2750
Occasional Contributor

Is there a way to select specific cells from a list that only show within a data validation set?

 

For example:  I have a list of fruits (Apple, Pears, Grape, Banana), but for this data validation I (the user) only want to show Apple and Grape so checkbox them so these are the only 2 fruits that appear in the drop down list in the 2nd tab.

 

Obviously the earliest option is to just delete the fruits I don't want in the list but I want the list to stay the same, so it can be reused time and time again without having to reproduce the list.

 

I have attached an example sheet with the contents that I am looking to use.

1 Reply

Hi @Carlos2750,

 

You could try using a Dependent Drop Down List to do this. There is a blog post on Trump Excel (https://trumpexcel.com/dependent-drop-down-list-in-excel/) that explains how to do this.

 

I hope this helps!

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
48 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
30 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies