Excel: Fit To Page vs. Full Page Option for Printing a Chart

Last reviewed: November 2, 1994
Article ID: Q46510

SUMMARY

When you are printing a chart with Microsoft Excel version 2.20 or later, the following three options in the Page Setup dialog box relate to the size of the printed chart. Note: Excel versions 1.50 and earlier do not offer the Full Page option.

   Option        Description
   ------        -----------

   Screen Size   Excel prints the chart exactly the same size as it
                 appears on the Macintosh screen.

   Fit To Page   Excel prints the chart as large as possible on the
                 selected paper size while keeping the same ratio of
                 height to width.

   Full Page     Excel expands both the chart height and width as far
                 as possible to fit on the page, ignoring the
                 on-screen ratio of height to width.

MORE INFORMATION

As noted above, if you are using Excel 1.50 or earlier, the Full Page option is not available. To print full size charts in these versions of Excel, you must shape the chart on screen so that the Fit To Page option can expand the chart.

The Fit To Page option in Page Setup is intended to expand the chart proportionately to fit the print width and print height you have specified in Page Setup. The key idea is that Excel will expand the chart proportionately to fit the page. In other words, if your chart is short, it will print short and wide regardless of the print height and print width.


KBCategory: kbother
KBSubcategory:

Additional reference words: 1.00 1.03 1.04 1.06 1.50 2.20 3.00


THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.

Last reviewed: November 2, 1994
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.