For this method, select the file using File/Place, making sure Show import options is turned on, and click Open. Solution 2: Change an import optionĪnother solution lies in placing the Excel file into InDesign rather than copying it. However, there is a consequence of changing this preference: from this point forward until the preference is changed again, any text that is copied and pasted from another application will be pasted as text only, and that isn’t good if you want to maintain formatting for other items that will be copied and pasted in the future, so you might want to reset the option back to All Information. It worked! The numbers have changed while the table formatting remains the same. For the option When Pasting Text and Tables from Other Applications, make sure Text Only is selected, and click OK. Let’s go back a few steps and try copying the data from Excel again, but before pasting the data into InDesign, change a key preference from the Clipboard Handling section of the Preferences dialog box. How about the paste without formatting option? In this instance, nothing is being pasted! Solution 1: Change a key preference It pasted, but the formatting of the text in the table has been lost, and some colors in the table have changed. Paste the data into a new text frame into InDesign, then copy and paste the data from there.

What about instead of paste, we try using the paste without formatting option instead? No… the same thing happens.

No… instead the data has pasted as a table with the first table cell. More after the jump! Continue reading below↓įree and Premium members see fewer ads! Sign up and log-in today.

Linking text boxes in indesign for mac