Printing - Fit to Page

[Suggie]

I've created a workbook, certain tabs of which will be printed for presentation purposes.
All page set up options have been set up - Print area, fit to page 1 by 1. However, when the page prints, there is sometimes lots of wasted white space - Is there any way to 'stretch' the page to the maximum possible, similar to how you can stretch a bitmap in Powerpoint?

 

[Jtorres13]

It depends on the "dimensions" of the area being printed. If the area to be printed much wider than long, when the Fit to 1 by 1 takes hold, it shrinks the whole thing down proportionally and it looks like there's wasted space.

Can you tell us where is the space being wasted> Is it more waste at the top or bottom tha to the sides, or is it all around? Can you post a picture of the Preview screen?

 

[Gavona]

I have certainly come across this. I explicitly define the print area. In print Preview I use the Margins button to confirm that there are no empty columns being included but SOMETHING is fooling excel. In my examples I am normally (always?) Trying to fit 1 wide by blank long. Problem is it over reduces (but still fills the entire page length and hoes onto the next). Works 99% of the time and fails 1% of the time. Often just one sheet in a workbook behaves like this so it is nothing to do with printer driver. I usually just manually set the % scaling for those odd sheets.

Sorry, I know this doesn't help - but you are not alone!

Gavin

 

[GlennUK]

When this happens to me, it's usually unused columns or rows that cause it. Any area of the spreadsheet that has been accessed will be taken as being part of the "Used Area" even if the contents have been cleared. Excel prints the Used Area if not specific print area has been chosen. Do Ctrl-End to see where Excel thinks the last used cell is, and delete any unused columns or rows. I generally close the workbook and reopen after doing that, as sometimes Excel doesn't reset the Used Area properly, and that forces it to do reset.

Cheers, Glenn.

Did you hear about the literalist show-jumper? He broke his nose jumping against the clock.

 

[Suggie]

I've double checked that I have set the print area for just the part of the document that I want to print;

Jtorres13 - The space that is being 'wasted' appears to be predominantly on the left and right.