for anyone having same problem in 2025 my solution based on Aerials code

• from your google docs view on top ribon find: extensions-> apps scripts (that will open script editor in new tab with active bound to your doc)

• paste below script

• adjust row limit (2016 in my case)

• click run above script (it should save automatically if script has no errors)

• authenticate with google use of your scripts (akcnowledge that you take risk upon yourself if you run malicious code)

• go back to your google docs tab and there click "ok" to allow script to run

• depending on size of document it may take a while to see effect, in my case, on 2k+ row table took about 2-3 minutes

  function fixCellSize() { DocumentApp.getUi().alert("All row heights will be minimized to content height."); var doc = DocumentApp.getActiveDocument(); var body = doc.getBody(); var tables = body.getTables(); for (var table in tables) { //iterates through tables for (var i=0; i < 2016; i++){ //iterates through rows in table // in i<number : number deffines how many rows (automatic did not work so just retype correct oen for your doc or if you are smart enought find currently working function) Logger.log("Fantasctic!"); table.getRow(i).setMinimumHeight(1); } } }