I often use 'Fit Sheet on One Page'. However this works by shrinking the printout so that it fits on one page.

If your sheets print area height/width ratio is out to the ratio of the sheet you are printing on then there will be wasted white space on the sides of the sheet.

My idea is to alter the ratio of the print area so that it matches the ratio of an A4 sheet (1:1.414)

I aim to alter the ratio by proportionally increasing the widths of all columns in the print area.

However before I write this, I need a reliable way to measure the height (being the combined heights of all rows in the print area) and the width (being the combined widths of all columns in the print area). I do know how to get the width of one column or height of one row - but how do I quickly pickup the total height/width of the print area?

Suggestions on how to measure this anyone? (Code appreciated if you can)