| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Drag and drop data only??
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? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Drag and drop data only??
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. -- HTH... Jim Thomlinson "Chanda" wrote: 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? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Drag and drop data only??
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. "Jim Thomlinson" wrote: 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. -- HTH... Jim Thomlinson "Chanda" wrote: 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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Drag & Drop | Excel Worksheet Functions | |||
| drag and drop | Excel Discussion (Misc queries) | |||
| drag and drop editing | Excel Discussion (Misc queries) | |||
| drag and drop will not turn off - keeps selecting all data | Excel Discussion (Misc queries) | |||
| Drag and drop | New Users to Excel | |||
Linear Mode
