There are often times when reports or data sets are larger then what can normally fit on one page. When ever this happen I usually go into page break view or set rows/columns to fit to one page. This works great for getting what you need down to one page. However whenever I print that one sheet it prints out small and only takes up half of the page and leaves a lot of white space.
Is there a way to make excel print larger or take up more of the page after customer setting the print area or adjusting the margins. It would be very helpful to take advantage of the extra white space or make the what is printed larger after fitting to one page.
thanks
