microsoft excelmicrosoft word
I have a set of Word documents, each document contains a table set up for printing so it prints on one full A4 page. Now I need to copy those tables to Excel, but the copy operation doesn't preserve Word table cell size, so I need to manually adjust it to make the table in excel fit one full page. Is there a way to copy a table from Word to Excel and preserve cell size?
I am using Office 2007.
Thank you in advance.
Name the range, Sheet2!R1C1:R8C2, as an Excel table (Insert->Tables-Table). Let's call this tbSheet2
Create a name that points to the table(Formulas->Defined Names->define Name). Let call it sh2Table and point it to tbSheet2[#All]
Change the file code to the table name. With the example below, the change is:
{LINK Excel.Sheet.8 "C:\Users\myAccount\Documents\testexcel.xlsx" "Sheet2!**sh2Table**" \a \p}
In case anyone else runs into this, I was able to synthesize a solution from the updates and other comments above. When you paste the data from Excel into Word, choose Paste > Paste Special..., then choose the Paste Link radio button, and Unformatted Unicode Text. Looks like this in Office 2016:
If your content actually has some formatting, one of the other options might be better. In my case I just wanted the plain text content, which I was then able to style in Word to match its context.
Best Answer
I'm afraid the answer to that question is no.
To make your life marginally easier, though, you can, in Excel, select all the columns containing the table you pasted in and double click the border between them (ie, the border between the column letters in the column header) to autosize the columns to their contents.