Forum Discussion
Move column without inheriting the Data Validation?
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.
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.
5 Replies
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.
SergeiBaklan Oh, wow. That's tricky. And it works. Thanks very much!
bvelke , you are welcome
