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. Some additional things to look into are: see more, on the file menu, click print, start excel and create a new workbook, more information, or workaround.
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 print a blank page in Excel 2007?
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
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.
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.
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.
A frequent inquiry we ran across in our research was “What is the correct order of the pages in the book?”.
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.