Printing cannot go close to edge of paper

[Angus]

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.

[Rae Drysdale]

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?
--
Rae Drysdale


"Angus" wrote:

> 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.

[Angus]

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.

"Rae Drysdale" wrote:

> 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?
> --
> Rae Drysdale
>
>
> "Angus" wrote:
>
> > 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.

[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.



"Angus" <[email protected]> schreef in bericht
news:[email protected]...
>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.

[Angus]

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.

"H." wrote:

> 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.
>
>
>
> "Angus" <[email protected]> schreef in bericht
> news:[email protected]...
> >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.
>
>
>

[Bryan Hessey]

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

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

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

Do you have papersize A4 as your papersize, and if so do you have any 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 print extra lines on the page.

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

Any further clues?

--

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.

"H." wrote:

> 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.
>
>
>
> "Angus" <[email protected]> schreef in bericht
> news:[email protected]...
> >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.
>
>
>

[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.


"Angus" <[email protected]> schreef in bericht
news:[email protected]...
>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.
>
> "H." wrote:
>
>> I guess you ordered it to 'fit on one page'?
>>

[xomarwr82]

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