Discrepancy between display and print

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

johnpanning@aol.com - 28 Nov 2007 15:52 GMT

I am experiencing difficulty in fitting text in Excel. A line of text
shown as fitting within a single sheet in Normal View and Page Layout
View will run across onto a second page when seen in Print Preview.
This is especially noticeable when fixed spacing fonts are used
(Courier, in this case), but is evident to some degree with any font.
I thought it might be related to some problem involving different or
missing screen or print fonts, but this problem does not occur in Word
with the same fonts.

This is frustrating because what appears to fit on the page on the
screen almost invariably requires a second page to print.

Thanks for your help.

Reply to this Message

Art - 28 Nov 2007 17:03 GMT

> I am experiencing difficulty in fitting text in Excel. A line of text
> shown as fitting within a single sheet in Normal View and Page Layout
[quoted text clipped - 9 lines]
>
> Thanks for your help.

John,
Go to the "Print Setup/Page" tab. Experiment with the "Scaling" options:
"Adjust" and "fit" to resize. If it's just a width fit issue, try
setting "Fit to 1 Pages wide" and make the "tall" setting blank.

Just be cognizant of the fact that these operate on the entire "Print
Area" setting, not on a per page basis.

You may want to play with the "Print Setup/Margins Center Options on
Page" tab settings as well. These do work on a per-page basis.

Another tip: In Excel's "Print Preview" mode, click on the little yellow
ruler icon. This will bring up drag bars for the the body and
header/footer area margins. Any changes made here in "Print Preview"
mode will be back-annotated into your "Page Setup" margin settings.

Art

Reply to this Message

Mac Forum / Applications / Excel / November 2007

Discrepancy between display and print