Results 1 to 6 of 6
  1. #1
    Gold Lounger
    Join Date
    Feb 2004
    Location
    Cape Town, RSA
    Posts
    3,444
    Thanks
    0
    Thanked 1 Time in 1 Post

    Multiple row selection, copy to Word (2003)

    Is it possible to only paste the selected non contiguous range into Word without all the bits inbetween pasting too?

    If I select A1:C1 and A5:C5 and A10:C10 - Copy - Switch to Word and Paste, it pastes A1:C10!!! Is there a way to only paste the original copied range?

    Tx
    Regards,
    Rudi

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Multiple row selection, copy to Word (2003)

    Option 1: copy the non-contiguous selection, paste it elsewhere in Excel, copy the pasted contiguous range, then paste into Word.

    Option 2: hide the rows you don't want to copy (in your example rows 2:4 and rows 6:9).

  3. #3
    Gold Lounger
    Join Date
    Feb 2004
    Location
    Cape Town, RSA
    Posts
    3,444
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Multiple row selection, copy to Word (2003)

    <img src=/S/stupidme.gif border=0 alt=stupidme width=30 height=30>
    I noticed that if I copy the non contiguous range, and paste it first in excel, then recopy the pasted range and switch to Word, then I get what I want.

    It is still weird that the whole range pastes though!!!

    PS: Sorry for my lapse of common sense!
    Regards,
    Rudi

  4. #4
    Gold Lounger
    Join Date
    Feb 2004
    Location
    Cape Town, RSA
    Posts
    3,444
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Multiple row selection, copy to Word (2003)

    TX

    Your option 2 is interesting. This works inversely to my original question. If you hide rows and paste in Excel, it pastes all the data, but in Word it pastes only the visible data. Iknew about Excel seeing the hidden data, but its new to me that it does not paste the hidden data in Word. Cheers for that tip!
    Regards,
    Rudi

  5. #5
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    6,280
    Thanks
    3
    Thanked 191 Times in 177 Posts

    Re: Multiple row selection, copy to Word (2003)

    If you're using a recent version of Office, you can also copy the three ranges individually, switch to Word, show the Office clipboard and then paste the three ranges in one at a time. Bizarrely, it pastes them all as one table!
    HTH
    Regards,
    Rory

    Microsoft MVP - Excel

  6. #6
    Gold Lounger
    Join Date
    Feb 2004
    Location
    Cape Town, RSA
    Posts
    3,444
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Multiple row selection, copy to Word (2003)

    Bizarrely, it pastes them all as one table! >>> Unless you enter after each paste! You can also paste all in one using the Paste All button.
    Tx for the tip!
    Regards,
    Rudi

Posting Permissions

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