Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #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
 



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 01:36 AM.


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