ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   a blank page appears at the end of a printout in excel (https://www.excelbanter.com/excel-discussion-misc-queries/211709-blank-page-appears-end-printout-excel.html)

steven

a blank page appears at the end of a printout in excel
 
How can I remove a blank page from the printout in Excel

Dave Peterson

a blank page appears at the end of a printout in excel
 
You could just put it back in the printer tray <bg.

Or you could change the print area:
File|print area|set print area
(after you select the range you want printed)

But you may find that if you just reset the last used cell, excel will determine
the correct range to print.

You can find some techniques at Debra Dalgleish's site for resetting the last
used cell:
http://www.contextures.com/xlfaqApp.html#Unused

Steven wrote:

How can I remove a blank page from the printout in Excel


--

Dave Peterson

Shane Devenshire[_2_]

a blank page appears at the end of a printout in excel
 
Hi,

I believe that is a printer issue, not an Excel issue (assuming your print
range does not extend to a blank page. To check this see if print preview
displays the blank page. If it does use the command on the first tab of Page
Setup to say Fit to Pages... For example 2 Wide and then clear the Tall
argument will for Excel to fit the printout to 2 pages wide and as many tall
as it needs.

If this helps, please click the yes button

Cheers,
Shane Devenshire

"Steven" wrote:

How can I remove a blank page from the printout in Excel



All times are GMT +1. The time now is 04:26 AM.

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