Hi all,
I’m currently trying to import my company’s Excel spreedsheet pricelists into Indesign so I can have a bit more creative freedom without things snapping to random places for no reason.
I already know that I can place tables and link them through from Excel to update each time someone makes an amend to the master pricelist and that if I style the table using cell styles and paragraph styles linked through table styles that the formatting will remain each time an update is applied.
However I’ve stumbled upon another issue (yay) – my table has subheadings in it and it seems that every time I add a new row to the bottom of a section in the Excel sheet and update the modified link in Indesign, the data moves down the table but the formatting stays with the original cells, meaning that my subtitle becomes body text and my new line of data becomes a sub-heading.
In short, is there any way to ‘stick’ formatting to certain text within Indesign rather than to particular cell co-ordinates (if that makes any sense at all)? Or is this an actual impossibility?
Help! I don’t like designing in Excel :(!
Jenny
.
