ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   How do I get rid of an extra page before printing on an excel sp. (https://www.excelbanter.com/excel-worksheet-functions/94535-how-do-i-get-rid-extra-page-before-printing-excel-sp.html)

delhi

How do I get rid of an extra page before printing on an excel sp.
 
I have multiple pages on multiple sheets on excel. Pagination is set up
under Custom Footers. An extra page prints at the end of each "sheet", thus
throwing off the pagination of the sheets that follow. How do I print only
those pages that contain information?

Mallycat

How do I get rid of an extra page before printing on an excel sp.
 

You need to work out why it is printing blank pages. By default, it
wont do this. Try going into *page break preview *mode so you can see
where the blanks are coming from. You can drag the boundaries in this
mode to remove the blanks

Matt


--
Mallycat
------------------------------------------------------------------------
Mallycat's Profile: http://www.excelforum.com/member.php...o&userid=35514
View this thread: http://www.excelforum.com/showthread...hreadid=552870



All times are GMT +1. The time now is 10:15 AM.

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