Sun, 8 Jul 2007 20:53:35 -0400 from Meebers :

"Stan Brown" wrote in message
t...
Sun, 8 Jul 2007 15:31:14 -0400 from Meebers :
I have a spreadsheet with 4 pages, and I want to print them on a
single sheet of 8x10 in a greeting card format. i.e. Page folded
in half is page 1 opening is page 2 and 3 and on the back is
page 4. Each page (footer) then has its own page number and
title.

File
Page Setup
Page
Scaling
Fit to (and select 1 by 1 page)

Stan...unless I do not understand, scaling and fit to 1x1 gives me
all four pages scrunched to the far left, 3/4 of the 8x10 page is
blank.

Check your page margins. I could be wrong, but I don't think I've
ever seen the behavior you describe.

As a work around, until I can figure out how to do it, I saved the
file as *.rtf and pasted it into my publisher 07 and chose a
greeting card format 5.5x8.5, told the printer it would be two
sided, printed one side, fliped the page over and printed on the
other side. I still have to tweak the heck out of it.

Maybe when you did this before you did it in your printer settings?
Many printers (my Brother printer is one) can print 4-up. Unset
the"Fit to", then do File | Print and change printer properties.
Every printer has different dialogs, so I can't tell you where in the
printer properties you should look.

--
Stan Brown, Oak Road Systems, Tompkins County, New York, USA
http://OakRoadSystems.com/