Results 1 to 4 of 4
  1. #1
    New Lounger
    Join Date
    Feb 2004
    Posts
    2
    Thanks
    0
    Thanked 0 Times in 0 Posts

    copyingt in excel (2002/SP2)

    How can I select adjacent columns to copy into word? When I do the normal ctrl-select and copy, and then copy into word, I get all the columns in between the two I have selected. GRRR!

  2. #2
    Uranium Lounger
    Join Date
    Dec 2000
    Location
    Salt Lake City, Utah, USA
    Posts
    9,508
    Thanks
    0
    Thanked 6 Times in 6 Posts

    Re: copyingt in excel (2002/SP2)

    Try clicking the first column then shift-clicking the last, then copy. Post back if this doesn't help. (Excel 2000 does not let me copy multiple columns selected by Ctrl-clicking.)
    -John ... I float in liquid gardens
    UTC -7ąDS

  3. #3
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: copyingt in excel (2002/SP2)

    I assume you mean non-adjacent columns, since adjacent columns have no columns between them. <img src=/S/grin.gif border=0 alt=grin width=15 height=15>

    If you do an extra step and copy it someplace in excel first you will have the columns selected and adjacent then copy, and paste into word then delete in excel, so the sequence is:
    Highlight the non-adjacent columns,
    select unused worksheet location
    paste ctrl-v
    copy (ctrl-c)
    goto word
    paste
    back to excel
    <delete>

    Steve

  4. #4
    New Lounger
    Join Date
    Feb 2004
    Posts
    2
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: copyingt in excel (2002/SP2)

    Thanks Steve - it's ridiculous to have to find a work around for this! Yes I do want non adjacent columns, so what you suggest will work

Posting Permissions

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