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

checklist

Say Thank You

Has somebody at Easykey impressed you?

Pick a Reward

Customer Thanks

  • Thanks No. 206

    Marie Pickavant has awarded Dominic a Virtual Choccy because "The whole experience of having an MOT...

  • Thanks No. 205

    Romilda has awarded Claire a Virtual Flowers because "Claire is always friendly and personable.She...

  • Thanks No. 204

    Pam Shaw has awarded Lisa a Virtual Bunch of Flowers because "Lisa, as the 'front desk' person,...

  • Thanks No. 203

    Derk Collinge has awarded Barry a Virtual Wine because "He...