Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 389
Default a blank page appears at the end of a printout in excel

How can I remove a blank page from the printout in Excel
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 35,218
Default 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
  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3,346
Default 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

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Wrapping text at end of page, and cells widths different when printout david Excel Discussion (Misc queries) 3 November 7th 07 01:40 AM
Im trying to remove blank rows in an Excel spreadsheet Printout riponalong Excel Worksheet Functions 2 January 5th 06 05:58 AM
suppressing a footer only on the first page of a printout Paul James Excel Discussion (Misc queries) 4 January 26th 05 06:26 AM
suppressing a footer on the first page of a printout Paul James Excel Discussion (Misc queries) 1 January 25th 05 11:57 PM
Excel File Appears Blank Tony C. Excel Discussion (Misc queries) 2 December 7th 04 12:59 AM


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

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"