Drag and drop data only??
in [General]
|
From: Chanda on 22 Dec 2009 11:28 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?
From: Jim Thomlinson on 22 Dec 2009 11:37 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?
From: Chanda on 22 Dec 2009 11:46 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?
|
Pages: 1 Prev: EXCEL 2007 VERY SLOW WITH LARGE DATA CHARTS Next: Unable to Unprotect a 2003 .xls file |