ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   how do i copy an excel spreadsheet into word document with a table (https://www.excelbanter.com/excel-discussion-misc-queries/173920-how-do-i-copy-excel-spreadsheet-into-word-document-table.html)

DB

how do i copy an excel spreadsheet into word document with a table
 
I have an 2007 excel spreadsheet I want to copy to a 2007 word document that
has a table that is equal to the number of cells in the excel spreadsheet.
How do I copy the excel data into the table in the word document?

J. Sperry[_2_]

how do i copy an excel spreadsheet into word document with a table
 
Before you paste, select all of the appropriate cells in the Word table.

Interesting sidenote: Word doesn't care if your selection isn't the same
dimension as what's in the clipboard. If you don't select enough cells in
the Word table, it will paste only enough to fill the cells selected. If you
select too may cells in the Word table, it will repeat the paste into the
extra rows/columns as needed to fill the selection.

"db" wrote:

I have an 2007 excel spreadsheet I want to copy to a 2007 word document that
has a table that is equal to the number of cells in the excel spreadsheet.
How do I copy the excel data into the table in the word document?



All times are GMT +1. The time now is 11:21 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com