When I cuit and paste from an Excel table to an Indesign table, I lose all the Excel formating (indents, etc). Is there a way of transferring data but retaining the formatting?
There are a couple of ways.
1. Place instead of Paste and set the Import Options (click box in lower left corner of import dialog after file selected) as shown in first screenshot
2. Ensure your Clipboard preferences are set to keep the styles, swatches, etc. as poointed out in the second screenshot
Retrieving data ...