Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I print worksheets merged
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I print worksheets merged
Try looking in excel help files under shared workspaces. I am sure it will
become a simple task once the shared workspaces are created. "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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I print worksheets merged
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I print worksheets merged
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 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I print worksheets merged
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 DataFilterAutoFilter. 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 -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I print worksheets merged
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. "Harold" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Print all charts in a workbook (multiple worksheets) | Charts and Charting in Excel | |||
how can i print my worksheets as book | New Users to Excel | |||
How to copy print set up to other excel worksheets? | Setting up and Configuration of Excel | |||
how can I get all worksheets to print at one time? | Excel Worksheet Functions | |||
How can I print a specified page from several worksheets in Exce. | Excel Worksheet Functions |