To adjust the scale of your Excel document for optimal printing, you can modify the sheet size to fit the page width or a specified number of pages.

Regardless of the size of your table, it‘s possible to ask Excel to adjust the scale of your document for printing.

To do this, go to the print settings. There you will find the following menu that allows you to configure the layout.

By choosing the Fit to option, you have several options:

  • With 1 page(s) wide by 1 tall: Adjust the document to fit entirely into 1 page.
  • With the settings 1 page(s) in width by empty tall (delete entry): Adjust the document to fill the entire width of the sheet but can be on several pages.
  • With the empty page(s) in width by 1 tall settings: Adjust the document to fill the entire height of the page.

This layout menu can be accessed from the print setup page, via the Page Setup button.

Now, you can directly configure the scaling of your document from the last option in the print settings.

You can also find these settings directly in your document, in the Page Layout menu, Scale to fit option.

You can configure how many pages your document should print on:

  • Width
  • Height
  • or choose a Scale

By clicking on the arrow at the bottom right, you will find the complete configuration menu.