Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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?

share|improve this question
You have to use Paste Special to avoid bringing the formatting across. – Rhys Gibson Mar 4 '11 at 1:39

on a filled cell, you will see a little square block in the lower right corner. Place you pointer over the block and it becomes a plus sign. drag your info the destination box and when you release your mouse button, you will see a box with a plus sign next to the newly filled cell. Click on the plus sign and choose the fill without formatting option. This leaves you with only the raw data being transferred.

share|improve this answer

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .