Excel Printing - Fit To Page

[APElliott]

Hello,

Is it just me or is Excel no good at fitting a print area to a page.

I've used Lotus 123 (which I hate), and it printing options seem great.

I've tried reseting margins etc, and resizing columns and rows, but the result are the same - the data always falls miles short of the margins.

Is there anything to solve this?

Thanks

Andrew

 

[dsi]

Under File > Page Setup, choose the Page Tab. There is a scaling option so that you can fit the output to x pages wide by y pages tall. If it's a multi-page document and you just want to fit the width, set the "y pages tall" to something that exceeds your needs.

 

[Bowers74]

Hi Andrew,

Mark the area you want to print, and go to File->Print Area->Ste Print Area . . .. This will set the print area to the range that you have currently selected.

Then you could also use dsi's suggestion.



Peace!

Mike

Never say Never!!!
Nothing is impossible!!!

 

[smah]

Or if you want it fit to full page width, but don't care about how many pages long, in the Page setup set the width to 1 page wide and delete the value for page length.