ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   How do I get Excel to not print blank pages when using outlines (https://www.excelbanter.com/excel-worksheet-functions/106917-how-do-i-get-excel-not-print-blank-pages-when-using-outlines.html)

Excel Challenged

How do I get Excel to not print blank pages when using outlines
 
I have several spreadsheets that when I click the upper left hand box to
apply formatting to the whold document such as shows outlines, my document
will print out and then I'll have several pages that are blanket with just
the outlines printing. I have one document that is 5 pages and when I apply
formatting to whole document, 1400 blanks will print out. How do I get rid of
these excess pages

kassie

How do I get Excel to not print blank pages when using outlines
 
Set a print range, or alternatively, do not format the whole sheet, if you
only need to format a small portion of it. <File,<Print Area,<Set Print
Area

"Excel Challenged" wrote:

I have several spreadsheets that when I click the upper left hand box to
apply formatting to the whold document such as shows outlines, my document
will print out and then I'll have several pages that are blanket with just
the outlines printing. I have one document that is 5 pages and when I apply
formatting to whole document, 1400 blanks will print out. How do I get rid of
these excess pages



All times are GMT +1. The time now is 02:28 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com