Discrepancy between display and print

[johnpanning]

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.

 

[Art]

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.

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