Re: Printing document to fit the entire page
Try Print Preview then click the set up tab. When the Page setup screen appears click the "Page" tab. Set the scaling to "1 page" wide by however many tall. If this forces your spreadsheet to squash vertically just increase the number of pages tall option. Dont forget to set your print area under the file menu in the normal view (not Print Preview). I'm not trying to patronise you but highlight the cells you want to print then select "File", "Print Area" then "Set Print Area".
Hope this helps.
Video Tutorials / Excel Dashboards Reports