Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 01-12-2016, 04:02 PM
Jiing Chiang Jiing Chiang is offline Copy + Pasting Excel Tables in word have 8pt spacing Windows 10 Copy + Pasting Excel Tables in word have 8pt spacing Office 2016
Novice
Copy + Pasting Excel Tables in word have 8pt spacing
 
Join Date: Jan 2016
Location: Australia
Posts: 11
Jiing Chiang is on a distinguished road
Default 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?



Reply With Quote
  #2  
Old 01-13-2016, 02:44 AM
macropod's Avatar
macropod macropod is offline Copy + Pasting Excel Tables in word have 8pt spacing Windows 7 64bit Copy + Pasting Excel Tables in word have 8pt spacing Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

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]
Reply With Quote
  #3  
Old 01-13-2016, 11:00 PM
Jiing Chiang Jiing Chiang is offline Copy + Pasting Excel Tables in word have 8pt spacing Windows 10 Copy + Pasting Excel Tables in word have 8pt spacing Office 2016
Novice
Copy + Pasting Excel Tables in word have 8pt spacing
 
Join Date: Jan 2016
Location: Australia
Posts: 11
Jiing Chiang is on a distinguished road
Default

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!
Reply With Quote
  #4  
Old 01-14-2016, 01:49 AM
macropod's Avatar
macropod macropod is offline Copy + Pasting Excel Tables in word have 8pt spacing Windows 7 64bit Copy + Pasting Excel Tables in word have 8pt spacing Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

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
This is more flexible than using a fixed width, as it allow the table to resize to fit whatever margins & page layout you're using (such as when changing between portrait and landscape).
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #5  
Old 01-14-2016, 05:43 PM
Jiing Chiang Jiing Chiang is offline Copy + Pasting Excel Tables in word have 8pt spacing Windows 10 Copy + Pasting Excel Tables in word have 8pt spacing Office 2016
Novice
Copy + Pasting Excel Tables in word have 8pt spacing
 
Join Date: Jan 2016
Location: Australia
Posts: 11
Jiing Chiang is on a distinguished road
Default

Quote:
Originally Posted by macropod View Post
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
This is more flexible than using a fixed width, as it allow the table to resize to fit whatever margins & page layout you're using (such as when changing between portrait and landscape).
Thank you so much for you help. It worked perfectly!
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Copy + Pasting Excel Tables in word have 8pt spacing 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
Copy + Pasting Excel Tables in word have 8pt spacing help Copy from excel and pasting as a metafile in powerpoint Juiceapple Office 1 09-15-2009 09:52 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 09:48 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft