+ Reply to Thread
Results 1 to 2 of 2

Using paste special to link excel cell range to word doc = adds dotted line border?

  1. #1
    Registered User
    Join Date
    04-24-2014
    Location
    California
    MS-Off Ver
    Excel 2010
    Posts
    1

    Using paste special to link excel cell range to word doc = adds dotted line border?

    Good morning.

    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.

    Thanks!!

    -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.

    Help!!!

  2. #2
    Registered User
    Join Date
    05-03-2013
    Location
    Los Angeles
    MS-Off Ver
    Excel 2003
    Posts
    31

    Re: Using paste special to link excel cell range to word doc = adds dotted line border?

    Hi, mfletch74.
    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.



    Best regards,
    Arron
    Best Regards,
    Arron

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Copy excel range and paste special picture (metafile) into existing word dot VBA
    By Markcuss in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 12-06-2012, 08:21 PM
  2. Copy data range from excel to word as an image (i.e. paste special)
    By papasideris in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-21-2012, 09:54 AM
  3. Link Word Multiple Line Data into Excel Single Cell
    By mohanvamsi_18 in forum Excel General
    Replies: 0
    Last Post: 01-21-2010, 03:52 AM
  4. [SOLVED] cell border is dotted line
    By Table4two in forum Excel General
    Replies: 1
    Last Post: 10-31-2005, 03:05 PM
  5. RE: cell border is dotted line
    By Naz in forum Excel General
    Replies: 0
    Last Post: 10-31-2005, 02:05 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1