Excel printing

  • Thread starter Thread starter dj
  • Start date Start date
D

dj

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?
 
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
 
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.
 
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
 
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






- Show quoted text -
Click to expand...

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.
 
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






- Show quoted text -
Click to expand...

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.
 
Back
Top