Share via

Is there a way to permanently change the page layout to "Fit To Page" on Excel 2011 Mac?

Anonymous
2014-01-09T19:45:57+00:00

Recently switched from PC to Mac.. been having issues printing Excel spreadsheets.  (Running Excel 14.3.9)

Every time I open a new worksheet or a previously saved worksheet, I have to change the layout to "Fit to Page" instead of "Scale" to get it to print correctly.  Is there a way to permanently change this setting so I don't have to do it EVERY TIME I print something?

Thank you in advance!

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

Answer accepted by question author

  1. Bob Jones AKA CyberTaz MVP 435K Reputation points
    2014-01-10T14:23:05+00:00

    It isn't clear why you're having to do this in "every" workbook or what the "issues" are :-)

    The 2 features you mention are actually one in the same -- simply different methods of imposing scaling of the content. The Fit To option allows Excel to scale the content as necessary whereas the Scale value allows you to specify the preferred percentage yourself. [Pursuant to that, Fit To adjusts Scale value but entering a Scale value does not activate (i.e., check the box for) Fit To settings.] For example, I have a file which is too wide to fit on a single sheet of paper based on paper size & margin settings. If I use Fit To for 1 page wide x 1 page tall Excel automatically sets the Scale value to 83%. If I clear the Fit To check Excel sets the Scaling value back to 100%. IOW, Fit To is a convenience feature for Scaling the Print Area.

    Additionally, Scaling is worksheet specific. It is neither a workbook setting nor a global Excel preference. Each sheet in a book can have a different scaling percentage based on the volume of content in its Print Area & the needs for that particular sheet. Further, the values set are saved with the workbook file, so each time the file is opened each sheet's Layout specifications are as they last were, assuming the workbook was saved after the adjustments were made.

    If you'll provide a more detailed description of the problem perhaps someone can offer some explanations & useful suggestions.

    1 person found this answer helpful.
    0 comments

2 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2016-09-02T13:16:11+00:00

    I am not sure if this is the same question but what I have recently discovered is an attachment I received is only printing part of the workbook. It is only after I select the entire workbook or print area that I can print it. How do I set it so I can open or create and print and get everything? Thanks!

    0 comments
  2. Anonymous
    2014-01-10T01:23:45+00:00

    Try this:

    Open Page setup and adjust the zoom level.  Set their affect not only view on screen; but, how its printed.

    Another method is go to Page setup and choose.Options which goes to the actual Printer Setup menu. You can adjust the zoom level there as well.

    0 comments