Home

Data Validation in Excel

%3CLINGO-SUB%20id%3D%22lingo-sub-1051417%22%20slang%3D%22en-US%22%3EData%20Validation%20in%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1051417%22%20slang%3D%22en-US%22%3E%3CP%3E%3CSPAN%3EHave%20a%20single%20list%20of%20contiguous%20data%20and%20want%20to%20choose%20portions%2C%20i.e.%2C%20non-contiguous%20cells%20for%20data%20validation%20list.%20Use%20CTRL%20key%20to%20choose%2C%20but%20get%20error%20message.%20Is%20it%20possible%20to%20do%20this%20error-free%3F%20There%20are%20no%20empty%20cells%20in%20the%20source.%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1051417%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1051436%22%20slang%3D%22en-US%22%3ERe%3A%20Data%20Validation%20in%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1051436%22%20slang%3D%22en-US%22%3EPlease%20upload%20a%20sample%20spreadsheet.%20It's%20hard%20to%20picture%20what%20you're%20talking%20about%20in%20any%20really%20meaningful%20manner%3B%20the%20actual%20would%20help%20greatly.%3C%2FLINGO-BODY%3E
miamdjd
Occasional Visitor

Have a single list of contiguous data and want to choose portions, i.e., non-contiguous cells for data validation list. Use CTRL key to choose, but get error message. Is it possible to do this error-free? There are no empty cells in the source.

1 Reply
Highlighted
Please upload a sample spreadsheet. It's hard to picture what you're talking about in any really meaningful manner; the actual would help greatly.
Related Conversations
Pivot table Changing Cell Formula
ahlamalbadah in Excel on
0 Replies
Average without #VALUE!
Crackeriano in Excel on
0 Replies
multiple same set columns
Jon_E1972 in Excel on
2 Replies
Struggling how to do a calculation
Tim_Jevans in Excel on
4 Replies
vlookup
Novice6 in Excel on
1 Replies