Sheet Size (not file size)

Hello,

Does anyone know if there is a macro out there that minimizes the physical size of a spreadsheet - so that it fits on the smallest sized printout? I'm looking for something that will play with column and row width/height of a large spreadsheet and come back with an "optimized" solution.

* No sample document.

Thank you,

Vitaly

How about something like this?

Please Login or Register  to view this content.

So Autofit doesn't always optimize, it has trouble with wrapped text and knowing how much it can push the width together at the expense of height. When I do it manually it almost requires playing around with the manual autofit function. I think the issue is that autofit considers just the row/hight but not the spreadsheet as a whole.

What you are asking is a human choice. There is no "best", especially if your dealing with wrapped text and odd formatting like merge cells.

The page setup/print features in Excel provide some means for fitting content, but it does it in 2 primary ways: spreading it across pages and/or scaling all of the content. It does so base don the print area that has been defined. Basically an all or nothing approach.

You can use the built in autosize feature, in which case Excel decides what is best which may differ from you or someone else's concept of what the best fit would be or you can tell Excel what size to use for rows/columns. This can be done static or potentially using some sort of calculation I guess...but itd be quirky and likely not help. The issue is as per the first point and scaling. What fits within a row or column now when printing may not scale the same as more/less rows/columns are in the print area and Excel scales everything to fit in your desired page setup. Ex: a column at 10 width may fit all the content just right now because its scaled at lets say 54% (even fit x by y pages becomes a scaled %) and the next time you go to print the content requires a scale of 45% (presuming rows/columns added), meaning everything is smaller, meaning the content may get cut off at the same column width (10) as before.

Usually people decide how many pages wide x tall they are willing to have, how many rows/columns they are willing to have on each sheet...and then size rows/columns to fit into that paradigm as this way you are limiting the scaling and your efforts sizing rows/columns isnt superseded by scaling.

Fair enough. I was hoping there would be a way to optimize to the most "square" shape or one that would
overall take the least amount of sqr inches for the whole document. It makes sense that this is not built out somewhere.

Thanks,