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. I did it once several years ago and has
burned my brain trying to figure out how to do it again. (The list has been
updated and therefore need a reprint.) TIA for any suggestions.

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 Brown, Oak Road Systems, Tompkins County, New York, USA
http://OakRoadSystems.com/

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. 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.


"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 Brown, Oak Road Systems, Tompkins County, New York, USA
http://OakRoadSystems.com/

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/