Share this article...

Isn't it annoying when you print your spreadsheet and some columns spill onto continuation pages?

Microsoft Excel

To force Excel to print your spreadsheet on one page do this:

1. Whilst you have the spreadsheet open click the excel file tab (File) tab

2. Now click the Print button (in the left hand menu)

3. Click on the No Scaling option (last one in the list)

excel scaling

The following are the settings usually most useful to select...

Fit Sheet on One Page

Select this if you want the whole spreadsheet on one page. Tale a look at the preview on the right - it might be too small!

If you have many columns going across with relatively few rows - you will see a big gap in the lower half of the preview.

If so, try changing Portrait Orientation to Landscape Orientation to make it bigger

Fit All Columns on One Page

Select this option if you have a very tall spread sheet.  In the Fit on One Page (portrait view) there will be a big white space to the right of the preview making the text too small

This option may create several pages but force all the columns to fit one page wide (so extra columns do not annoyingly print on separate pieces of paper)

If the text still looks tiny (because you have a good number of columns, you could try changing Portrait Orientation to Landscape Orientation to make it bigger

Note: After saving your workbook the spreadsheet will also 'remember' your printer settings.

Instructions for older versions of Excel

Share this article...
Was this article helpful? Add your comment below...

Design Your Excel Training


Say Thank You

Has somebody at Easykey impressed you?

Pick a Reward

Customer Thanks

  • Thanks No. 158

    Suzanne has awarded Denis Virtual Choccy because "You will need it after China and to ward off...

  • Thanks No. 157

    Marina has awarded Dominic a Virtual Beer because "I want to thank you for your...

  • Thanks No. 156

    John has awarded Denis Virtual Cake because "he sorted out my...

  • Thanks No. 155

    Ricky has awarded Dominic a...

This website uses cookies to help us improve your experience.
By using our website you accept our Privacy Policy and use of cookies.