Forum Discussion
bvelke
Jun 04, 2019Brass Contributor
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 validati...
- Jun 04, 2019
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
Jun 04, 2019Diamond Contributor
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.
- bvelkeJun 05, 2019Brass Contributor
SergeiBaklan Oh, wow. That's tricky. And it works. Thanks very much!
- SergeiBaklanJun 05, 2019Diamond Contributor
bvelke , you are welcome
- ExcelloverSep 29, 2019Copper Contributor
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?SergeiBaklan