#1
|
|||
|
|||
Copy + Pasting Excel Tables in word have 8pt spacing
Hi,
I use an excel spreadsheet to assist in calculations and auto-filling in tables that are then copy and pasted in a Word document template with mirrored tables. I can paste the table into the word document using the 'Keep Source Formatting' paste option. However, the width of the table in excel far exceeds the width of the margins in the Word document. This is why I've setup tables that mirror that of the excel ones except formatted to fit appropriately within the page margins. As a result, I'd like to copy and paste the data in the cells of the table in Excel into the cells of the mirrored table in Word. However, no matter how I do this, the data seems to paste into the Word table with 8pt spacing after it. This then requires further manual adjustment. I'd like it so that I can just copy and paste the data into the mirrored cells in the Word table with 0pt spacing. Is this possible? |
#2
|
||||
|
||||
The format in Word will be dictated by the paragraph Style being used. Your screen shots don't reveal that or what the underlying paragraph format is.
In any event, if you paste the table into Word using the 'Keep Source Formatting' paste option, simply going into Table Tools|Layout|Properties>Table, setting the 'preferred width' to something less than the page width should resolve the matter.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#3
|
|||
|
|||
Thanks for your response, macropod!
Your advice worked great! However, is there a way to set the page settings or something along those lines to ensure that the preferred width of all pasted tables are 15cm? (15cm was the setting I used which seemed to fit perfectly within my margins). I realise it isn't that much effort to paste the table, highlight it, right click table properties then just set the preferred width to 15cm, but my aim is to maximise the efficiency of the production of these word documents. As a result, my aim is to make it so there is no manual 'work-around', and the table can be pasted directly into word with no further adjustments being required (such as spacing, or width etc). Was this at all possible? Thank you again for your assistance so far, it's greatly appreciated! |
#4
|
||||
|
||||
There is no setting to make the tables autofit the pauge. However, you could use a macro like the following and assign it to a keyboard shortcut, then run it on the table you've just inserted:
Code:
Sub FitTable() With Selection If .Information(wdWithInTable) = True Then With .Tables(1) .AllowAutoFit = False .PreferredWidthType = wdPreferredWidthPercent .PreferredWidth = 100 End With End If End With End Sub
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#5
|
|||
|
|||
Quote:
|
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Copy tables and transpose them from Word to Excel | Story11 | Word VBA | 2 | 01-18-2015 07:28 AM |
Pasting tables from Excel 2010 into Word 2010 - How to fix column widths? | GracieB | Word | 7 | 10-02-2013 06:24 AM |
copying and pasting Excel tables into Word | derohanes | Word | 1 | 01-24-2013 12:07 AM |
how to copy all ms word tables into excel | rehan129 | Word | 0 | 01-28-2012 10:17 AM |
help Copy from excel and pasting as a metafile in powerpoint | Juiceapple | Office | 1 | 09-15-2009 09:52 AM |