On the File menu, click Print. Note In Excel 2007, click the Microsoft Office Button, and then click Print. Under Print range, select only the page or pages that you want to print. The following steps must be completed for both of the following examples:.
It turns out this issue is caused by having different Page Setup options on each worksheet. For example, Excel can’t print two pages with different paper sizes to the same “piece of paper” (actually a PDF in this case). Instead, it insists on having two different PDFs to print to, one for each paper size.
Another thing we wanted the answer to was, how do I control the printing on a multi-page spreadsheets?
Another way to control the printing on multi-page spreadsheets is by setting a certain width, height, or scale. At the Page Layout Ribbon, click the dropdown box next to Width–from here, you can set a specific number of pages to print across.
Why does excel print so small?
Click the File tab at the top-left corner of the window. Click Print in the column at the left side of the window. Click the button above the blue Page Setup link, then select the No Scaling option.
The next thing we asked ourselves was why is my spreadsheet too small when I print it?
If you’re using Excel’s “Scaling” feature to automatically size a spreadsheet to fit the dimensions of a printed page, you may have a problem where the page is printed much too small. Both print preview and the printed speadsheet do not fill the page, but instead appear as a small thumbnail or in miniature size rather than filling up all.
The next thing we asked ourselves was why won’t my Excel spreadsheet print?
Perhaps a certain section of your spreadsheet never printed or the spreadsheet took too many pages to print. Whatever went wrong, you can avoid many printing problems in Excel by following certain tips, such as tweaking the margins, setting the print area, scaling the sheet to print, and choosing the right sheet options.
How to scale to fit before printing Excel spreadsheets Another way to control the printing on multi-page spreadsheets is by setting a certain width, height, or scale. At the Page Layout Ribbon, click the dropdown box next to Width–from here, you can set a specific number of pages to print across.
Why do I have extra blank pages in excel?
In Microsoft Excel, when you print a worksheet, pages that are completely blank may be unexpectedly printed. This behavior can occur under any of the following conditions: The only data on a page is in cells that are formatted in such a way that they are blank.
A cell on the page contains an error, and errors have been selected to print as blank. There are completely blank pages ahead of any pages that contain data (including the first two conditions stated here), which print as blank.
How to fix blank pages are unexpectedly printed in Excel?
Blank pages are unexpectedly printed in Excel 1 Symptoms. In Microsoft Excel, when you print a worksheet, pages that are completely blank may be unexpectedly printed. On the File menu, click Print. Note In Excel 2007, click the Microsoft Office Button, and then click Print.
Note In Excel 2007, click the Page Setup dialog box launcher in the Page Setup group on the Page Layout tab. On the Sheet tab, under Print, in the Cell error as drop-down box, click
Select the pages with content you need to print with holding the Ctrl key. See screenshot: 1., and see screenshot:.
Why does the print preview or the printed speadsheet not fill the page?
Both print preview and the printed speadsheet do not fill the page, but instead appear as a small thumbnail or in miniature size rather than filling up all of the available space. This can be caused by the “print titles” feature in the page setup window.