Printing cannot go close to edge of paper

[Guest]

I have several spreadsheets which refuse to print to near the edge of the
paper, no matter how I alter the various print settings. See the attached
screenshot:
http://www.tebsin.com/screenshot.png

Notice how the printed area is about 2 inches from the left and right
margins. On the Page tab I have got ample "Fit to" pages wide and tall.

Why is this happening?

Thanks in advance.

 

[Guest]

You have selected centre horizontally and vertically, so the whole
spreadsheet is centred on the page. You can widen the columns to use more of
the page, or you might also be able to scale it up slightly. If you take off
the horizontal centring it will move back to the left margin. Does this
explain things?

 

[Guest]

If I remove centering that will move it to the left and leave a bigger gap at
the right - how do I make it stretch across the whole page?

Thanks.

 

[H.]

I guess you ordered it to 'fit on one page'?

In that case the allover sheetsize will be reduced to fit the paper. So, if
the sheet is to high, Excel will shrink height and create left and right
borders to fit it. Keeping proportions correct.

I also have this often when Excel is fitting to a page. But usually I have
the top/bottom borders to wide as my original excelsheet would be broader
than my fysical printpage. So it squeses it on the left and right creating a
bottom border.

To only solution I found for this problem, is to play with row and column
heights/widths AND, more important, with the textsize. But often you will
not find this to help.

H.

 

[Guest]

I wish that were the cause. The screen shot you see is the first page of a
4 page print, I have print hight set to 50.

 

[Bryan Hessey]

The appearance is, as was said, that you are affected by the 'Fit t
Page' setting. I am curious about your saying that "-I have got ampl
"Fit to" pages wide and tall"- and wonder why you would have the 'Fi
to Page' set.

If you untick 'Fit to Page' does the print widen?

Have you inserted Page Breaks to break the page at the appropriat
points?

Do you have papersize A4 as your papersize, and if so do you have an
form of Letter/A4 conversion setting on your print setup?

Normally, the print you showed would be fewer lines and wider display
if you restrict the width the number of rows printed will (of course
be affected, is there any reason your print is attempting to prin
extra lines on the page.

Does View, Page Break Preview allow you to adjust the page sizes ?

Any further clues?

--

 

[H.]

Angus,

I guess you say set to 50 lines to print'?
If so, if you say 'set to 50' , this means to me that it IS a case of 'fit
to screen'.

When I have a A4 size of paper in landscape, I get something of max 40 lines
on it. So you have more. So excel has to shrink it to fit your 50 lines on
one page.

H.

 

[xomarwr82]

Try to reset print area, and change the scalingfrom 1 page wide by 5
pages tall, to 2 pages wide by 50 pages tall