| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I print multiple worksheets of a work book onto one page?
|
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Page Setup Across Multiple Worksheets | Excel Worksheet Functions | |||
| print 2 worksheets on the same page side-by side | Excel Discussion (Misc queries) | |||
| Continuous page numbers in workbook of multiple worksheets | Excel Discussion (Misc queries) | |||
| Printing multiple worksheets on one page | Excel Discussion (Misc queries) | |||
Hybrid Mode
