When working with data, drag-and-drop can dramatically speed up the workflow. Sometimes we work on files which already have their formatting in place, such as borders and colors. When I want to move data around, drag-and-drop is the most intuitive thing to do. BUT, it totally wrecks the formatting. It destroys the formatting from the source and carries it to the destination.
How can we prevent this from happening? How do I set it up so that only data gets transferred using drag-and-drop?