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. A few more items to pay attention too are start excel and create a new workbook, on the file menu, click print, workaround, more information, or see more.
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.
Why do I get blank pages when I print?
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.
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
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:.
Which order does excel print pages in?
, and a. Top-left section, top-right section, bottom-left section, and bottom right section b. All the odd numbered pages, then all the even numbered pages.
One of the next things we wanted the answer to was; by default excel prints page in what order?
You can control the order in which worksheet pages are numbered and printed when the data does not fit on one page. By default, Excel prints pages from the top down and then left to right on the worksheet, but you can change the direction to print pages from left to right and then from the top down.
How do I change the Order of printing in Excel?
By default, Excel prints pages from the top down and then left to right on the worksheet, but you can change the direction to print pages from left to right and then from the top down. Click the worksheet for which you want to change the printing order.
What does blank cells mean in a worksheet?
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. The worksheet contains drawing objects that are located in unexpected areas of the worksheet.
How do I change the Order of pages in a sheet?
Click the Sheet tab, and then under Page order, click Down, then over or Over, then down. Tip: The direction of each option is displayed in the preview box.
Top-left section, top-right section, bottom-left section, and bottom right section b. All the odd numbered pages, then all the even numbered pages c. All even numbered pages, then all the odd numbered pages.