ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Printed multiple pages per sheet (https://www.excelbanter.com/excel-discussion-misc-queries/171282-printed-multiple-pages-per-sheet.html)

hmm

Printed multiple pages per sheet
 
I have a wide, short table that runs across two pages, but the second page
would easily fit on the same printed sheet underneath the first. How can I
specify in Excel to print two pages on one sheet. (This would be much like
Word's multiple pages-per-sheet print option.) Thanks.

Jim Rech[_2_]

Printed multiple pages per sheet
 
Excel does not have the ability to re-arrange the layout of your sheet when
it prints. I'd suggest a cut/paste or two to get what you want. After
printing you can do some undos or simply close this workbook without saving
and open the original.

--
Jim
"hmm" wrote in message
...
|I have a wide, short table that runs across two pages, but the second page
| would easily fit on the same printed sheet underneath the first. How can
I
| specify in Excel to print two pages on one sheet. (This would be much
like
| Word's multiple pages-per-sheet print option.) Thanks.



hmm

Printed multiple pages per sheet
 
Thanks Jim. That's actually what I did. Chalk that one up as another
suggestion to Microsoft!

"Jim Rech" wrote:

Excel does not have the ability to re-arrange the layout of your sheet when
it prints. I'd suggest a cut/paste or two to get what you want. After
printing you can do some undos or simply close this workbook without saving
and open the original.

--
Jim
"hmm" wrote in message
...
|I have a wide, short table that runs across two pages, but the second page
| would easily fit on the same printed sheet underneath the first. How can
I
| specify in Excel to print two pages on one sheet. (This would be much
like
| Word's multiple pages-per-sheet print option.) Thanks.




Ron de Bruin

Printed multiple pages per sheet
 
Maybe this is a option for you
http://www.rondebruin.nl/print.htm#non-contiguous


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"hmm" wrote in message ...
Thanks Jim. That's actually what I did. Chalk that one up as another
suggestion to Microsoft!

"Jim Rech" wrote:

Excel does not have the ability to re-arrange the layout of your sheet when
it prints. I'd suggest a cut/paste or two to get what you want. After
printing you can do some undos or simply close this workbook without saving
and open the original.

--
Jim
"hmm" wrote in message
...
|I have a wide, short table that runs across two pages, but the second page
| would easily fit on the same printed sheet underneath the first. How can
I
| specify in Excel to print two pages on one sheet. (This would be much
like
| Word's multiple pages-per-sheet print option.) Thanks.




hmm

Printed multiple pages per sheet
 
Nice suggestion. I am not familiar with Paste Picture Link, because Excel
2000 does not have it. Anyway, I am only concerned with cells themselves, so
Paste Link is a good solution. Thanks.

"Ron de Bruin" wrote:

Maybe this is a option for you
http://www.rondebruin.nl/print.htm#non-contiguous


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"hmm" wrote in message ...
Thanks Jim. That's actually what I did. Chalk that one up as another
suggestion to Microsoft!

"Jim Rech" wrote:

Excel does not have the ability to re-arrange the layout of your sheet when
it prints. I'd suggest a cut/paste or two to get what you want. After
printing you can do some undos or simply close this workbook without saving
and open the original.

--
Jim
"hmm" wrote in message
...
|I have a wide, short table that runs across two pages, but the second page
| would easily fit on the same printed sheet underneath the first. How can
I
| specify in Excel to print two pages on one sheet. (This would be much
like
| Word's multiple pages-per-sheet print option.) Thanks.






All times are GMT +1. The time now is 02:00 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com