Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Drag and Drop in Excel
- Thread starter sunnymean
- Start date
DaleWatson123321
Programmer
sunnymean,
I don't know of a method of using drag & drop to insert an Excel Workbook into Word.
First, the term "Workbook" (as you probably are aware) refers to an "entire" Excel file, which could comprise multiple "Worksheets" (up to 256) within that one Workbook.
Second, a "Worksheet" can comprise up to 256 columns and up to 65,536 rows.
As I'm sure you can now appreciate, "dragging and dropping" a Workbook or Worksheet does NOT seem to be "realistic" or possible. I would therefore respectfully suggest you be more specific in terms of what it is you would like to "drag and drop".
For example, if you are talking a specific range of cells, then you should specify that.
In the case of a range of cells, I'm also not aware of a "drag and drop" method. If this is possible, I'm sure someone from Tek-Tips will inform the both of us.
The following, I believe, would be the "normal" method:
1) Highlight the range of cells, and use <Control> C to Copy.
2) Use <Alt> <Tab> to go to your Word document.
3) From the menu, use Edit - Paste Special
4) Click on Microsoft Excel Worksheet Object, and IF you want to maintain a "link" to the Excel file, choose "Paste link".
Hope this helps.
Regards, ...Dale Watson dwatson@bsi.gov.mb.ca
I don't know of a method of using drag & drop to insert an Excel Workbook into Word.
First, the term "Workbook" (as you probably are aware) refers to an "entire" Excel file, which could comprise multiple "Worksheets" (up to 256) within that one Workbook.
Second, a "Worksheet" can comprise up to 256 columns and up to 65,536 rows.
As I'm sure you can now appreciate, "dragging and dropping" a Workbook or Worksheet does NOT seem to be "realistic" or possible. I would therefore respectfully suggest you be more specific in terms of what it is you would like to "drag and drop".
For example, if you are talking a specific range of cells, then you should specify that.
In the case of a range of cells, I'm also not aware of a "drag and drop" method. If this is possible, I'm sure someone from Tek-Tips will inform the both of us.
The following, I believe, would be the "normal" method:
1) Highlight the range of cells, and use <Control> C to Copy.
2) Use <Alt> <Tab> to go to your Word document.
3) From the menu, use Edit - Paste Special
4) Click on Microsoft Excel Worksheet Object, and IF you want to maintain a "link" to the Excel file, choose "Paste link".
Hope this helps.
Regards, ...Dale Watson dwatson@bsi.gov.mb.ca
- Status
Similar threads
- Locked
- Question