How do I print worksheets merged

[Guest]

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

 

[Guest]

Try looking in excel help files under shared workspaces. I am sure it will
become a simple task once the shared workspaces are created.

 

[Guest]

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.

 

[Guest]

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

 

[Debra Dalgleish]

Instead of storing each category on a different sheet, could you store
them on one sheet, with a column to indicate the category? Then, you
could summarize and print the data in a pivot table, or sort and print
it with all the data for each category listed together.

To view only the data for one category, you could use
Data>Filter>AutoFilter.

 

[Guest]

Take a look at Debra's suggestion below. That might be a viable way to deal
with it all. She kind of keyed in on one aspect of it that I didn't - the
fact that all of your sheets are laid out in the same fashion - that means
that adding a single column to indicate what groups things are in (which of
the original 15 sheets it would have been placed on if kept in separate
sheets) and using filtering to look at individual groups would be much like
looking at separate sheets.

Thanks for the feedback, and if her idea is one that would work for you,
I'll bet she'd love to hear that also.