Easykey

01279 777169

...keeping IT simple

Sunday, 20th May 2012

How do I force my spreadsheet to print on one piece of paper?

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.

Comments (0)
Write comment
Your Contact Details:
Comment:
You are here: Home Tips Excel Tips How do I force my spreadsheet to print on one piece of paper?