If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Excel printing
In Quattro Pro I was able to print a selection of data from several
sheets just by selecting the area in each sheet. Quattro Pro would then put all the selections onto one page and print. Is there a way to select data on several tabs in Excel 2007 and have them print on one page? |
#2
|
|||
|
|||
Excel printing
Not only will Excel not allow range printing from multiple sheets, it won't
allow printing non-contiguous ranges on the same sheet. Can you copy the range to print from each sheet to a new sheet? Or copy all data from each sheet to a new sheet then hide rows and columns you don't want to print? Gord Dibben MS Excel MVP On Tue, 28 Jul 2009 09:42:17 -0700 (PDT), dj wrote: In Quattro Pro I was able to print a selection of data from several sheets just by selecting the area in each sheet. Quattro Pro would then put all the selections onto one page and print. Is there a way to select data on several tabs in Excel 2007 and have them print on one page? |
#3
|
|||
|
|||
Excel printing
That would be too much work to achieve the goal. We use tabs for each
month of a rent collection database. To follow one tenant and print a monthly amount by selecting one line from each month is what we could do in Quattro Pro. By the sound of it, this is not possible in Excel. On Jul 28, 11:23*am, Gord Dibben gorddibbATshawDOTca wrote: Not only will Excel not allow range printing from multiple sheets, it won't allow printing non-contiguous ranges on the same sheet. Can you copy the range to print from each sheet to a new sheet? Or copy all data from each sheet to a new sheet then hide rows and columns you don't want to print? Gord Dibben *MS Excel MVP On Tue, 28 Jul 2009 09:42:17 -0700 (PDT), dj wrote: In Quattro Pro I was able to print a selection of data from several sheets just by selecting the area in each sheet. *Quattro Pro would then put all the selections onto one page and print. *Is there a way to select data on several tabs in Excel 2007 and have them print on one page?- Hide quoted text - - Show quoted text - |
#4
|
|||
|
|||
Excel printing
Not possible without using VBA to transfer the tenant's lines from each
sheet to a new sheet. Have you thought of having all tenants and months on one sheet and using autofilter? Gord On Tue, 28 Jul 2009 13:19:22 -0700 (PDT), dj wrote: That would be too much work to achieve the goal. We use tabs for each month of a rent collection database. To follow one tenant and print a monthly amount by selecting one line from each month is what we could do in Quattro Pro. By the sound of it, this is not possible in Excel. On Jul 28, 11:23*am, Gord Dibben gorddibbATshawDOTca wrote: Not only will Excel not allow range printing from multiple sheets, it won't allow printing non-contiguous ranges on the same sheet. Can you copy the range to print from each sheet to a new sheet? Or copy all data from each sheet to a new sheet then hide rows and columns you don't want to print? Gord Dibben *MS Excel MVP On Tue, 28 Jul 2009 09:42:17 -0700 (PDT), dj wrote: In Quattro Pro I was able to print a selection of data from several sheets just by selecting the area in each sheet. *Quattro Pro would then put all the selections onto one page and print. *Is there a way to select data on several tabs in Excel 2007 and have them print on one page?- Hide quoted text - - Show quoted text - |
#5
|
|||
|
|||
Excel printing
On Jul 28, 1:58*pm, Gord Dibben gorddibbATshawDOTca wrote:
Not possible without using VBA to transfer the tenant's lines from each sheet to a new sheet. Have you thought of having all tenants and months on one sheet and using autofilter? Gord On Tue, 28 Jul 2009 13:19:22 -0700 (PDT), dj wrote: That would be too much work to achieve the goal. *We use tabs for each month of a rent collection database. *To follow one tenant and print a monthly amount by selecting one line from each month is what we could do in Quattro Pro. *By the sound of it, this is not possible in Excel. On Jul 28, 11:23*am, Gord Dibben gorddibbATshawDOTca wrote: Not only will Excel not allow range printing from multiple sheets, it won't allow printing non-contiguous ranges on the same sheet. Can you copy the range to print from each sheet to a new sheet? Or copy all data from each sheet to a new sheet then hide rows and columns you don't want to print? Gord Dibben *MS Excel MVP On Tue, 28 Jul 2009 09:42:17 -0700 (PDT), dj wrote: In Quattro Pro I was able to print a selection of data from several sheets just by selecting the area in each sheet. *Quattro Pro would then put all the selections onto one page and print. *Is there a way to select data on several tabs in Excel 2007 and have them print on one page?- Hide quoted text - - Show quoted text -- Hide quoted text - - Show quoted text - Thanks for the idea, but no, the month's by tab works well and the tab already has numerous columns that must be tracked monthly. I guess I just like 'the good 'ol days' with Quattro Pro. It seems Excel is a little behind in this area. Oh well. |
#6
|
|||
|
|||
Excel printing
On Jul 28, 1:58*pm, Gord Dibben gorddibbATshawDOTca wrote:
Not possible without using VBA to transfer the tenant's lines from each sheet to a new sheet. Have you thought of having all tenants and months on one sheet and using autofilter? Gord On Tue, 28 Jul 2009 13:19:22 -0700 (PDT), dj wrote: That would be too much work to achieve the goal. *We use tabs for each month of a rent collection database. *To follow one tenant and print a monthly amount by selecting one line from each month is what we could do in Quattro Pro. *By the sound of it, this is not possible in Excel. On Jul 28, 11:23*am, Gord Dibben gorddibbATshawDOTca wrote: Not only will Excel not allow range printing from multiple sheets, it won't allow printing non-contiguous ranges on the same sheet. Can you copy the range to print from each sheet to a new sheet? Or copy all data from each sheet to a new sheet then hide rows and columns you don't want to print? Gord Dibben *MS Excel MVP On Tue, 28 Jul 2009 09:42:17 -0700 (PDT), dj wrote: In Quattro Pro I was able to print a selection of data from several sheets just by selecting the area in each sheet. *Quattro Pro would then put all the selections onto one page and print. *Is there a way to select data on several tabs in Excel 2007 and have them print on one page?- Hide quoted text - - Show quoted text -- Hide quoted text - - Show quoted text - Actually, you gave me a good idea. A summary sheet pulling all relevant data for an annual month by month total. Might be a little work to set up but may also have benefits down the road. Thanks again. |
#7
|
|||
|
|||
Excel printing
Sounds like a good idea.
Pursue it. Gord On Tue, 28 Jul 2009 17:24:52 -0700 (PDT), dj wrote: Actually, you gave me a good idea. A summary sheet pulling all relevant data for an annual month by month total. Might be a little work to set up but may also have benefits down the road. Thanks again. |
Thread Tools | |
Display Modes | |
|
|