+ Reply to Thread
Results 1 to 3 of 3

Copy/Paste an object to a different Excel file and retain text format

  1. #1
    Registered User
    Join Date
    09-11-2013
    Location
    Montreal, Qc, Canada
    MS-Off Ver
    Excel 2013
    Posts
    41

    Question Copy/Paste an object to a different Excel file and retain text format

    I have a group of objects (grouped text boxes) with predefined text and format (ex: first text box centered, the others aligned to the left) that I need to copy to another Excel file. It is very important that those remains as objects, not an image. However, when I paste it, the text format is lost (ex: everything it is now aligned to the right).

    Anyone?

    Thanks!

  2. #2
    Valued Forum Contributor Blake 7's Avatar
    Join Date
    10-01-2010
    Location
    Bogota, Colombia
    MS-Off Ver
    Excel 2010 64 bit and Excel 2007,
    Posts
    1,377

    Re: Copy/Paste an object to a different Excel file and retain text format

    i just created two text boxes with diferent formating, grouped the two, copied and pasted them to a different file and the formatting stayed exactly the same, so i'm not sure why it wouldn't work for you. Not sure if this is helpful or not.... if only for knowing it can be done!!
    Blake 7

    If your question has been answered, please click EDIT in your original post, click GO ADVANCED and set the PREFIX box to SOLVED.

    If any member's response has helped to solve your problem, please consider using the scales icon on the top right of their post to show your appreciation.

    http://failblog.org/

  3. #3
    Valued Forum Contributor Blake 7's Avatar
    Join Date
    10-01-2010
    Location
    Bogota, Colombia
    MS-Off Ver
    Excel 2010 64 bit and Excel 2007,
    Posts
    1,377

    Re: Copy/Paste an object to a different Excel file and retain text format

    are you talking about the text format within the box... just to be clear??

+ 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. Replies: 3
    Last Post: 10-02-2012, 06:17 AM
  2. [SOLVED] Unable to copy and paste a text file into excel
    By Jack40 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-23-2012, 10:53 PM
  3. Replies: 1
    Last Post: 10-17-2005, 04:05 AM
  4. How do I copy and paste Excel charts and retain formatting? Mine .
    By Ivan Lawler in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 02-18-2005, 10:06 AM

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