How do I print multiple worksheets of a work book onto one page?
 

How do I print multiple worksheets of a work book onto one page?
 

Kab10 Wrote:


This is one area where Lotus 1-2-3 has Excel beat. I remember you
could patch together a print range from anywhere in the Lotus workbook
and print it out on one page.

With Excel you will need to create a worksheet that looks like the
conglomeration you want to print by copying and pasting from several
worksheets onto a single "mirror" sheet.


--
CaptainQuattro
------------------------------------------------------------------------
CaptainQuattro's Profile: http://www.excelforum.com/member.php...o&userid=32763
View this thread: http://www.excelforum.com/showthread...hreadid=544553

How do I print multiple worksheets of a work book onto one pag
 

You could use past special and past a link from the last sheet to the other
sheets, then just print off the last sheet.

Copy the area of the other sheets you wish to print then on the last sheet
of the workbook use Paste Special then Paste Link.

Any updating of the sheets will be reflected in the final sheet which you
can format to print to suit


"CaptainQuattro" wrote:


Kab10 Wrote:


This is one area where Lotus 1-2-3 has Excel beat. I remember you
could patch together a print range from anywhere in the Lotus workbook
and print it out on one page.

With Excel you will need to create a worksheet that looks like the
conglomeration you want to print by copying and pasting from several
worksheets onto a single "mirror" sheet.


--
CaptainQuattro
------------------------------------------------------------------------
CaptainQuattro's Profile: http://www.excelforum.com/member.php...o&userid=32763
View this thread: http://www.excelforum.com/showthread...hreadid=544553