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.

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.

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.

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" schreef in bericht
...
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.

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" schreef in bericht
...
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.

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?

--

Angus Wrote:
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" schreef in bericht
...
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
------------------------------------------------------------------------
Bryan Hessey's Profile: http://www.excelforum.com/member.php...o&userid=21059
View this thread: http://www.excelforum.com/showthread...hreadid=537354

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" schreef in bericht
...
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'?

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


--
xomarwr82
------------------------------------------------------------------------
xomarwr82's Profile: http://www.excelforum.com/member.php...o&userid=31764
View this thread: http://www.excelforum.com/showthread...hreadid=537354