| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Printing Multiple sheets on ONE?
Hello all... I am trying to print 8 sheets on one paper... (EXAMPLE) SHEET 1 A B C D 1XXXX XXXX XXXXX XXXX 2XXXX XXX XXXX XXXX 3XXX XXXX XXXX XXXX 4XXXX XXX XXXX XXXX 5XXXX XXXX XXXX XXXX SHEET 2 A B C D 1XXXX XXXX XXXXX XXXX 2XXXX XXX XXXX XXXX 3XXX XXXX XXXX XXXX 4XXXX XXX XXXX XXXX 5XXXX XXXX XXXX XXXX Because I only have like 5-6 lines per sheet i want to condense them into one page thanks. T. -- onesidered ------------------------------------------------------------------------ onesidered's Profile: http://www.excelforum.com/member.php...o&userid=25977 View this thread: http://www.excelforum.com/showthread...hreadid=394382 |
|
#2
|
|||
|
|||
|
Maybe you can just create a new worksheet and copy|paste special values from
each worksheet to that new worksheet and print from there. In fact, you can copy the data as a picture and only have to do it once. Select your range edit|copy select A1 of that new worksheet shift-edit|Paste picture Link Repeat (but paste under each picture). Notice that if you change any of the real data, the picture also changes. Then just print those pictures. onesidered wrote: Hello all... I am trying to print 8 sheets on one paper... (EXAMPLE) SHEET 1 A B C D 1XXXX XXXX XXXXX XXXX 2XXXX XXX XXXX XXXX 3XXX XXXX XXXX XXXX 4XXXX XXX XXXX XXXX 5XXXX XXXX XXXX XXXX SHEET 2 A B C D 1XXXX XXXX XXXXX XXXX 2XXXX XXX XXXX XXXX 3XXX XXXX XXXX XXXX 4XXXX XXX XXXX XXXX 5XXXX XXXX XXXX XXXX Because I only have like 5-6 lines per sheet i want to condense them into one page thanks. T. -- onesidered ------------------------------------------------------------------------ onesidered's Profile: http://www.excelforum.com/member.php...o&userid=25977 View this thread: http://www.excelforum.com/showthread...hreadid=394382 -- Dave Peterson |
|
#3
|
|||
|
|||
|
Dave, you are the MAN... that worked out great.. I did the Paste Special Values. Thanx, T. -- onesidered ------------------------------------------------------------------------ onesidered's Profile: http://www.excelforum.com/member.php...o&userid=25977 View this thread: http://www.excelforum.com/showthread...hreadid=394382 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do i auto create multiple files from 1 with multiple sheets | Excel Worksheet Functions | |||
| Copying multiple sheets from one book 2 another and undertake spec | Excel Discussion (Misc queries) | |||
| Multiple sheets selected | Excel Discussion (Misc queries) | |||
| linking multiple sheets to a summary sheet | Excel Discussion (Misc queries) | |||
| CountIF across multiple sheets in a workbook | Excel Worksheet Functions | |||
Linear Mode
