View Single Post
 
Old 01-12-2016, 04:02 PM
Jiing Chiang Jiing Chiang is offline Windows 10 Office 2016
Novice
 
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