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
Highlighted
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
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
Tabs and Dark Mode
cjc2112 in Discussions on
50 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
32 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
15 Replies
Discussion - Updating our interface with Fluent touches
Elliot Kirk in Discussions on
102 Replies