Drag and drop data only??

C

Chanda

Hello,
I am working on a very large spreadsheet and need to drag and drop large
amounts of data. The problem is that when I do this is drags and drops my
borders also, leaving the empty cells with no borders. Is there anyway that
I can drag and drop my data only?
 
J

Jim Thomlinson

When you drag and drop use your right mouse button instead of the left. That
will give you a menu of options. Select Copy Values Only.
 
C

Chanda

Thank you Jim,
I tried this, and it did work as far as my borders are concerned, but since
it is a copy function rather than cutting the values, it left values in the
previous cells...and I need them to have no data. But I do appreciate you
taking the time to reply.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

drag and drop linked cel 3
drag and drop editing 3
How to Drag and Drop an Outlook email into Excel? 5
protect formulas in locked cells from changing if data is moved 3
How to drag data in cells without dragging the formats 3
Drag and drop using only the keyboard. 1
Drag and Drop Picture 1
missing drop down command 1

Top