Resizing Multiple Tables at Once

No, this is not within the InDesign feature set. Column widths and row heights are handled on a table-by-table basis and can't be controlled globally. Scripts and plug-ins enhance InDesign's feature set, and it looks like you have a couple of suggestions to check out.

~Barb

If you are working on a PC - you could use FREE version of my ID-Tasker - the only limitation is that you would have to click on each table to initiate the process - but all the formatting would be done automatically - height / width of rows / columns, conversion of regular rows into headers and vice versa, conditional styling based on the contents, counting rows / columns from the end of the table so tables can have different size, etc. - still quicker than doing it all manually and more flexible than custom script.

With paid version - you can process whole server - 100s of files, incl. subfolders, automatically - and each table can be styled differently - depends on its size, current styling, contents, location, etc.

And at the end you can automatically export PDF - or more than one using different profiles - as spreads / pages, individual pages, ranges, JPEGs, etc.

Unfortunately InDesign’s table and cell styles are very limited, to the point I consider them superfluous. Cell width and height cannot be included as style attributes. You could probably script it, and someone might have already done so. Below is a scripts and articel I found on CreativePro (formerly InDesign Magazine). Untried.

https://creativepro.com/sizing-tables-with-script/