Slightly OT (Maybe) printing problem

M

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

Stan Brown

Sun said:
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.
Click to expand...

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

Meebers

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

Stan Brown

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.
Click to expand...

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.
Click to expand...

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