Move column without inheriting the Data Validation?

[bvelke]

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.

[#2 · Accepted 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.

[#3]

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

[#4]

@bvelke , you are welcome

[#5]

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 

[#6]

@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:

Cut and Insert:

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.