Forum Discussion
Move column without inheriting the Data Validation?
- 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 Oh, wow. That's tricky. And it works. Thanks very much!
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
- SergeiBaklanSep 29, 2019Diamond Contributor
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.