3 Replies Latest reply on Apr 14, 2016 7:06 AM by UpStyleDesign

    Embed code into Excel to enable pasted text to split across rows in InDesign table

    UpStyleDesign Level 1

      This may be impossible to do, but allow me to explain what we are planning.

      We have an Excel sheet with hundreds of rows. In each row they are three main columns that we need to get into InDesign and be in a table, as well as further columns to the right that are going be be in rows below once in InDesign.

      As such, the table in InDesign is going to have multiple rows, with the first row containing the three cells and other rows containing either one cell, or multiple cells. I think this may be impossible, but is there a code that can be placed into Excel to force InDesign to place text into subsequent rows? At the moment, on pasting, InDesign just automatically adds extra columns.

      Any help appreciated.