CreativePro Forum

Return to Member Forum

• Author
  Posts
• • March 18, 2015 at 5:39 am #74007
    Jennifer South

    Member

    Hi,

    As part of my work, I have to create pricelists from Excel documents. The lists contain a mixture of old and new items, with the new items highlighted in bold. The lists are organised in numerical order, so these bold items are scattered throughout the list, with no regular pattern. It is essential that we keep this mixture of bold and regular items as this is the only way a customer can tell if an item is new.

    In the past, we have done this document in Quark and the only way we could find to keep the bold formatting was to copy and paste the Excel info into a Word document and then import the Word document into Quark which is a bit cumbersome. Is anyone aware of a way to get the document straight from Excel to Indesign, whilst maintaining the text styles assigned in Excel?

    May thanks,
    Jenny

  • March 18, 2015 at 5:52 am #74008
    David Blatner

    Keymaster

    The key is to turn on “All Information” in the ‘when pasting text and tables’ section in the Clipboard Handling section of the Preferences dialog box.

    However, then I think you may need to copy the info in Excel, paste into a new text frame in InDesign (where you’ll get a new table), and then copy from that table and paste into your original InDesign file.

    Alternatively, if it’s a new table that you’re importing for the first time, you can turn on Show Import Options in the place dialog box, and then set it to Formatted Table or Formatted Only Once.

• Author
  Posts