Results 1 to 5 of 5
  1. #1
    New Lounger
    Join Date
    Dec 2009
    Location
    Meridian, Idaho, USA
    Posts
    5
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Using EXCEL 2007 on a Win XP Pro SP3 pc -

    I want to copy and paste a row of cells between to separate instances (not workbooks) of EXCEL on the same PC and have the cell widths and formatting from the source come across to the target correctly. When attempting to do this, the "Paste Special" option does not work the same as when pasting between locations in the same instance of EXCEL.

    After doing some research, I doubt if this can be done. Any suggestions?

    Thanks, Rod

  2. #2
    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
    Either don't open them in different instances, or use code to write each value and cell format from one to the other. Option 1 is easier!
    Regards,
    Rory

    Microsoft MVP - Excel

  3. #3
    New Lounger
    Join Date
    Dec 2009
    Location
    Meridian, Idaho, USA
    Posts
    5
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Thanks, I'll try to figure out a way to use a workbook in the original instance per your suggestion. Rod

  4. #4
    WS Lounge VIP
    Join Date
    Mar 2002
    Location
    Newcazzle, UK
    Posts
    2,829
    Thanks
    136
    Thanked 483 Times in 460 Posts
    When I had to do this, the best I could get was the 'old-fashioned' Ctrl-C from one session, to a "Ctrl-V' in the other session.

    It couldn't copy the column widths but it ceratinly copied cell colours and values.

    zeddy

  5. #5
    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
    To copy column widths you would have to copy and paste COLUMNS not rows. Copying rows will only paste the row heights.

    If you did not want to copy all the data in the columns, you could (after copying and pasting the rows), COPY the appropriate columns and then paste -special the formatting of the columns...

    Steve

Posting Permissions

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