Merge rows instead of adjusting row height for wrapped text

[mortensonman]

Hello. I am an AutoCAD tech at an engineering firm. I am trying to make some cad files with linked ole spreadsheets. The engineers want to be able to edit the spreadsheets with excel, and we want the results to show up in the drawings when we open or print them in AutoCAD. One of the caveats of this is each cad file (or drawing) has a title & revision border block, so the spreadsheet must fit within. By hook or crook I've figured out that an Arial Narrow 9 point font and default row height ends up appearing the same as our CAD standard Arial 1/10in, hence the viewer of the drawing might not even realize it's an embedded spreadsheet. The drawing border allows for 95 rows of this font. I've figured out how to hide all the rows past row 95 in a spreadsheet, however the pesky word wrap cells keep increasing the row height instead of merging some of the existing 95 rows. The result is a spreadsheet too large to fit on one of our drawings. Is there any way to keep a finite number of rows that account for double & triple row heights? Side note, we aren't big fans of data links and AutoTable. Frequent crashes and table inaccuracies are why we try to avoid it.