Microsoft Office Forums

Go Back   Microsoft Office Forums > Microsoft Excel > Excel

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

Hi,

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?

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

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.

Gary
Reply With Quote
  #3  
Old 04-09-2012, 04:19 PM
macropod's Avatar
macropod macropod is online now Windows 7 64bit Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 10,329
macropod is a jewel in the roughmacropod is a jewel in the roughmacropod is a jewel in the roughmacropod is a jewel in the rough
Default

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.
__________________
Cheers,
Paul Edstein
[MS MVP - Word]
Reply With Quote
Reply
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 08:44 AM
Link and change source for multiple tabs from excel to powerpoint excel3 PowerPoint 1 01-19-2012 01: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 -8. The time now is 02:25 AM.


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