Printing 4 sheets on one page

[Circe]

Any way to print 4 sheets as one continuous printout?
Right now it shows each page, even though its grouped, as
a separate printout in print preview.

Excel 97, yes 97!

 

[Dave Peterson]

You have at least a couple of choices:

#1. Insert a new sheet and copy the data from the 4 worksheets into this one
and print from there (yech!).

#2. Insert a new sheet and copy a picture of your data into this worksheet and
print from there (yea!).

Insert the new sheet
Do this for each worksheet
Select your range
edit|copy
back to the new sheet
shift-edit|paste picture link
(by pasting a picture link, the picture will change when the range
changes--either values or formats!)

Do this for each sheet and print from that new sheet.