Using paste special to link excel cell range to word doc = adds dotted line border?
I am adding several cell ranges out of an excel spreadsheet into a word document using the paste special option. It works perfect except that the table shown in the word document has a dotted line along the right border of the table. This happens intermittently. Occassionally I can get it to go away only to have it reappear later. Any suggestions for fixing this that anyone has would be great!! I have listed the process that I'm using for linking the excel table to the word document below just in case I'm doing something there to cause the problem.
-Highlight cell range in excel document and use Ctrl+C to copy the range.
-Go to word document. Paste special -> Paste link ->select Microsoft Excel worksheet object -> Enter.
- Some copy and work fine. Others have the mysterious dotted line at the right of table.
Re: Using paste special to link excel cell range to word doc = adds dotted line border?
Fist of all, I need to know which kind of Word reader are you using to open and edit Word docs? Then, if you are using the WPS, you can select the option of "pasting text only without any formats" when you add several cell ranges out of an excel spreadsheet into a word document using the paste special option next time. I hope it helps. Good luck.
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)
By Markcuss in forum Excel Programming / VBA / Macros
Last Post: 12-06-2012, 08:21 PM
By papasideris in forum Excel Programming / VBA / Macros
Last Post: 05-21-2012, 09:54 AM
By mohanvamsi_18 in forum Excel General
Last Post: 01-21-2010, 03:52 AM
By Table4two in forum Excel General
Last Post: 10-31-2005, 03:05 PM
By Naz in forum Excel General
Last Post: 10-31-2005, 02:05 PM
Search Engine Friendly URLs by vBSEO 3.6.0 RC 1