Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

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
1  
You have to use Paste Special to avoid bringing the formatting across. –  Rhys Gibson Mar 4 '11 at 1:39

1 Answer 1

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

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.