Microsoft Office Forums

Go Back   Microsoft Office Forums > Microsoft Excel > Excel

LinkBack Thread Tools Display Modes
Old 03-28-2012, 02:12 AM
minny minny is offline Windows XP Office 2010 64bit
Join Date: Mar 2012
Posts: 1
minny is on a distinguished road
Default Link and Keep Source Formatting--not exact


I created a table in Excel. Am trying to paste this table into word. So i use: Paste--link and keep source formatting.

The problem is once i select "link and keep source formatting" i get extra space between rows.

HOw do i avoid the extra space between rows?

Reply With Quote
Old 04-03-2012, 12:16 PM
Gary Drumm Gary Drumm is offline Windows XP Office 2007
Advanced Beginner
Join Date: Mar 2012
Posts: 86
Gary Drumm is on a distinguished road

What version of Office are you using?
I just copied a tabel from Excel, and Pasted it into Word, and it was a perfect copy (with no spaces).
In fact I didn't have the option to Paste ---link and keep formatting as you suggested.
I didn't even have the "Paste Special" option available; simply Paste.

Using Office 2007.

Reply With Quote
Old 04-09-2012, 04:19 PM
macropod's Avatar
macropod macropod is offline Windows 7 64bit Office 2010 32bit
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 15,209
macropod is a name known to allmacropod is a name known to allmacropod is a name known to allmacropod is a name known to allmacropod is a name known to allmacropod is a name known to all

Hi Minny,

You'll probably get the result you're after by using Paste Special > Link to File and choosing the 'Excel Worksheet Object' or 'Picture (Enhanced Metafile)' paste format.

Gary: The OP's profile indicates Office 2010. If you want the data to be linked, you have to use 'link and keep formatting' (which may only be available in Office 2010) or the 'Paste Special' option. The 'Paste Special' option is available in Office 2007.
Paul Edstein
[MS MVP - Word]
Reply With Quote
Please reply to this thread with any new information or opinions.

Thread Tools
Display Modes

Similar Threads
Thread Thread Starter Forum Replies Last Post
Paste and keep source formatting lost moyali Word 5 04-17-2012 03:15 PM
paste option Keep source formatting missing through remote app mtrento Excel 1 03-07-2012 09:44 AM
Link and change source for multiple tabs from excel to powerpoint excel3 PowerPoint 1 01-19-2012 02:01 AM
editing source formatting urboyfriend Word 1 09-22-2011 02:43 AM
Keeping source formatting in Word 2003 texoz Word 0 06-30-2009 07:45 AM

All times are GMT -7. The time now is 03:33 AM.

Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc. is not affiliated with Microsoft