Hi Glyn,
I suspect you have cells with a large number of spaces
or non-breaking spaces on the right side of the cells.
Or possible a shape (image on the page).  Did you copy
the data from a web page.

Make a copy of your worksheet:

See if this makes a difference:
   Ctrl+A to select all cells on page and then run the
   TrimALL macro found on
        http://www.mvps.org/dmcritchie/excel/join.htm#trimall

Try deleting all shapes on the page, then do Print Preview:

Sub delShapesOnSht()
 'Dave Peterson, misc 2001-11-12, no loop required
 If ActiveSheet.Shapes.Count = 0 Then
    MsgBox "No Shapes on page for deletion"
    Exit Sub
 End If
 ActiveSheet.Shapes.SelectAll  '*** warning DELETE all Shapes
 Selection.Delete
End Sub

If that worked and you do have some shapes you want to keep
there are additional macros on my    shapes.htm   webpage.

The following would appear to do nothing for you since you
indicate that F55 shows up as your lastcell  (Ctrl+End)
but this is what I normally use for a single page.

 Select the cell you want to be the last cell   (F55)

 The MakeLastCell macro on my page:
    http://www.mvps.org/dmcritchie/excel/lastcell.htm#makelastcell
--
HTH,
David McRitchie, Microsoft MVP - Excel    [site changed  Nov. 2001]
My Excel Pages:  http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page:        http://www.mvps.org/dmcritchie/excel/search.htm

Since Mr McR has already given a long and complicated response I can only
assume I'm missing something, but is the obvious answer not to check if a
print area has been set? If it has, that would explain both the extra blank
page and the fact the scaling to 1x1 causes the genuine data to be squashed
up.

Possibly :)

Paul C,

You might try previewing the printed page and turning the margins on in the
previewing window.  If you don't see all of your rows and columns there (on
one page), grab the column marker closest to the right margin, and drag it
to the right.  This has worked for me when I had the problem you described.
Good luck.

Thanks for all your responses.

I did not have a print area set but there were a lot of trailing
spaces after the text in one of the cells. The data was downloaded
from an HP3000 manufacturing system as a text file and then imported
into the spreadsheet. I noticed it because the gridlines were missing
from the data until column J, so I did not need to use David's macro,
but it will no doubt come un useful in the future.

Thanks again for all your responses.

Glyn