Thanks a bunch! I was afraid that Excel cannot "stuff" the info into one in
order to save paper. After all my hours of research I came to the same
conclusion and your input confirms that I can stop searching. Your input is
greatly apprechiated!

Harold

"JLatham" wrote:

First, for some reason I get the impression that Sunday88310 was replying to
another topic somewhere.

As for your printing problem; Excel treats each separate worksheet (tab) as
a separate sheet to be printed. There isn't any way to tell Excel to take
the stuff off of Sheet2 and put it into Sheet1 to save paper at print time.

The way I'd approach the problem would be to create some VBA code attached
to the workbook's BeforePrint event that would pull all of the information
from all sheets into a single sheet and just print that one sheet and then
'scrap' the page, so to speak.

The non-programming way would be for you choose one sheet to hold all of the
data and then go to the other 14 sheets and copy from them and paste into the
chosen sheet, print that sheet and then delete the changes you made to that
sheet.

"Harold" wrote:

Hi!
I have created a Excel file with 15 different worksheets. that have all the
same layout, only different catagories. Now I was trying to print them merged
together, otherwise I am printing out 32 pages, where saving the empty bottom
parts of the sheet would scale it down to half.

When I am working in this file, I will be deliting rows as I need, leaving
sometimes only one row per sheet. It would be a waste of paper if I could not
print out the next sheet following directly the end of the first and so
keeping all sheets on a minimun of paper.

Please help! Having squared eyes for staring at the screen, trying to find
out about this myself.

Harold