As I recall, when pasting, you need to create a table in InDesign, and preselect exactly the same number of cells (x by y) as you're pasting. The cells you've selected will be replaced by the data you're pasting in.
The formatted table is in a template. The different data sets I'll be entering are easily 150-600 rows of information each from what I've seen so far (possibly longer), so I can't just select the rows I want to paste in. So far, I've been selecting one row of cells in the InDesign chart and pasted all the information from excel. It works if I have an excess of rows, but not if I have too few, which might be the case sometimes.
What I want it to do is run in offset text so I can continue placing the table on several pages with a continuing header/footer on each page without having all those extra rows. (I'm trying to make this process user friendly for other people.)
Is there a way that I can make the InDesign table expand to the number of rows I'm bringing in without having to manually look up how many rows there are in the excel sheet and enter that in the table window on InDesign every time to make it fit correctly?
Message was edited by: Roya R for grammar
Sorry, I don't know of an easy way to do that. There are no controls for that in InDesign. I assume it could be scripted, but I'm not a scripter.
Oh well. Thanks for your help.