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%3CLINGO-SUB%20id%3D%22lingo-sub-881157%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-881157%22%20slang%3D%22en-US%22%3E%3CP%3EWhen%20I%20try%20to%20use%20shift%20and%20drag%20data%20it%20replaces%20my%20data%20and%20not%20**bleep**.%3C%2FP%3E%3CP%3Ei%20get%20the%20message%20also%20%22there's%20already%20data%20here.%20Do%20you%20want%20to%20replace%20it%3F%22%3C%2FP%3E%3CP%3EVery%20annoying.%3C%2FP%3E%3CP%3EWhat%20should%20i%20do%3F%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%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-881242%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-881242%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F416916%22%20target%3D%22_blank%22%3E%40Excellover%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ENot%20sure%20what%20do%20you%20do%20incorrectly%2C%20but%20that%20means%20Shift%20doesn't%20work%20(cut%20and%20insert)%20and%20you%20try%20to%20move%20data.%26nbsp%3B%3C%2FP%3E%0A%3CP%3EIn%20which%20mode%20you%20are%20it's%20indicates%20visually.%3C%2FP%3E%0A%3CP%3EMove%20mode%3A%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20357px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F133999iB247129C0FFF27E7%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22image.png%22%20title%3D%22image.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3ECut%20and%20Insert%3A%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20374px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F134000i0696BC6727430CDC%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22image.png%22%20title%3D%22image.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3EPerhaps%20you%20released%20Shift%20button%20too%20early%20-%20you%20shall%20to%20keep%20it%20pressed%20till%20very%20end%20of%20the%20operation%2C%20after%20you%20release%20the%20mouse%20button%20to%20insert%20the%20column.%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.

5 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

When I try to use shift and drag data it replaces my data and not **bleep**.

i get the message also "there's already data here. Do you want to replace it?"

Very annoying.

What should i do?@Sergei Baklan 

@Excellover 

Not sure what do you do incorrectly, but that means Shift doesn't work (cut and insert) and you try to move data. 

In which mode you are it's indicates visually.

Move mode:

image.png

Cut and Insert:

image.png

Perhaps you released Shift button too early - you shall to keep it pressed till very end of the operation, after you release the mouse button to insert the column.

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
35 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies