Initially when I started creating TM1 reports in Excel I use to always change the page setup for printing to be either Fit to 1 page wide by 1 page tall or adjust the % until it looked right.
Nowadays I find it a lot easier to select fit to 1 page wide but blank out the page tall setting.
This
I find makes things a lot easier and more flexible.