SOLVED
Home

Move column without inheriting the Data Validation?

%3CLINGO-SUB%20id%3D%22lingo-sub-667083%22%20slang%3D%22en-US%22%3EMove%20column%20without%20inheriting%20the%20Data%20Validation%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-667083%22%20slang%3D%22en-US%22%3E%3CP%3EI%20want%20to%20move%20column%20G%20(which%20currently%20has%20no%20Data%20Validation)%20to%20between%20A%20and%20B%20(both%20of%20which%20have%20validation).%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIf%20I%20Cut%20and%26nbsp%3Bthen%20Insert%20Cut%20Cells%2C%26nbsp%3Bthen%20the%20moved%20cells%20inherit%20the%20validation%20rules%20from%20column%20A.%26nbsp%3B%20If%20I%20first%20Insert%20a%20column%20and%20then%20paste%20G%20into%20it%2C%20the%20moved%20cells%20inherit%20the%20validation%20from%20column%20B.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHow%20can%20I%20move%20column%20G%20with%20having%20those%20cells%20inherit%20any%20validation%20rules%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-667083%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-667160%22%20slang%3D%22en-US%22%3ERe%3A%20Move%20column%20without%20inheriting%20the%20Data%20Validation%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-667160%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F347015%22%20target%3D%22_blank%22%3E%40bvelke%3C%2FA%3E%26nbsp%3B%2C%3C%2FP%3E%0A%3CP%3ESelect%20column%20G%2C%20press%20Shift%20and%20drag%20it%20BEFORE%20column%20A%20(on%20first%20position).%20After%20that%20drag%20column%20B%20(former%20column%20A)%20on%20first%20position%20before%20former%20column%20G.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-670476%22%20slang%3D%22en-US%22%3ERe%3A%20Move%20column%20without%20inheriting%20the%20Data%20Validation%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-670476%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F521%22%20target%3D%22_blank%22%3E%40Sergei%20Baklan%3C%2FA%3E%26nbsp%3BOh%2C%20wow.%26nbsp%3B%20That's%20tricky.%26nbsp%3B%20And%20it%20works.%26nbsp%3B%20Thanks%20very%20much!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-672407%22%20slang%3D%22en-US%22%3ERe%3A%20Move%20column%20without%20inheriting%20the%20Data%20Validation%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-672407%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F347015%22%20target%3D%22_blank%22%3E%40bvelke%3C%2FA%3E%26nbsp%3B%2C%20you%20are%20welcome%3C%2FP%3E%3C%2FLINGO-BODY%3E
bvelke
Occasional Contributor

I want to move column G (which currently has no Data Validation) to between A and B (both of which have validation). 

 

If I Cut and then Insert Cut Cells, then the moved cells inherit the validation rules from column A.  If I first Insert a column and then paste G into it, the moved cells inherit the validation from column B.

 

How can I move column G with having those cells inherit any validation rules?

 

Thanks.

3 Replies
Solution

@bvelke ,

Select column G, press Shift and drag it BEFORE column A (on first position). After that drag column B (former column A) on first position before former column G.

@Sergei Baklan Oh, wow.  That's tricky.  And it works.  Thanks very much!

@bvelke , you are welcome

Related Conversations
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
*Updated 9/3* Syncing in Microsoft Edge Preview Channels
Elliot Kirk in Articles on
201 Replies
Early preview of Microsoft Edge group policies
Sean Lyndersay in Discussions on
65 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
2 Replies