Share this article...

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

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

1. Whilst you have the spreadsheet open click the Print Preview (Print Preview) button

2. Now click the Setup... button

3. Make sure you have selected the Page Tab and type a number 1 in Fit to: page wide and tall like this...

Fit Page

4. Click the OK button then the Print button

Note: After saving your workbook the spreadsheet will also 'remember' to print on one page.

Instructions for latest version 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...