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:.
You could be asking “Why can’t I print the same page twice in Excel?”
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.
Why excel print blank pages?
Blank pages are unexpectedly printed in Excel
Symptoms. In Microsoft Excel, when you print a worksheet, pages that are completely blank may be unexpectedly printed. The only data on a page is in cells that are formatted in such a way that they are blank. Start excel and create a new workbook, more information, see more, workaround, or on the file menu, click print are a couple more things to keep in mind.
One source stated that 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.
If the worksheet contains only several pages including blank pages, you can set all non-empty pages as print area, and then print this worksheet. Please do as follows. Select the pages with content you need to print with holding the Ctrl key.
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.
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.
How to delete extra empty or blank pages in a worksheet?
Select the pages with content you need to print with holding the Ctrl key. See screenshot: 1., and see screenshot:.