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...

Coronavirus COVID-19 Pandemic Policy

Design Your Excel Training


Say Thank You

Has somebody at Easykey impressed you?

Pick a Reward

Customer Thanks

  • Thanks No. 251

    Petronella has awarded Dominic a Virtual...

  • Thanks No. 252

    Janine has awarded Dominic a Virtual Wine because "He was very efficient doing the clean...

  • Thanks No. 250

    SK has awarded Denis Virtual Tea because "Shortcut key for desktop - great explanationand 3...

  • Thanks No. 249

    Ruth has awarded Dominic a Virtual...