ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Printing issue (https://www.excelbanter.com/excel-discussion-misc-queries/32115-printing-issue.html)

[email protected]

Printing issue
 

I have a question, and I would appreciate any tips on the most
efficient way to accomplish my task. I have a worksheet that has 3
pages of data when I print currently. The data is 2 narrow columns on
each page. I would like to take the data from each page, and put it
all on one page side by side ONLY FOR PRINTING purposes. I still want
the user to be able to look at the data as is, but I want the printing
to display the data on one page, with the columns from each page side
by side. I am thinking of copying and pasting the data on pages 2 and
3 to page 1 and then removing it ... but that seems a bit messy and
inefficient. Any tips/solutions would be appreciated.

Thank you,
Julia


Ron de Bruin

Hi Julia

See
http://www.rondebruin.nl/print.htm#non-contiguous

--
Regards Ron de Bruin
http://www.rondebruin.nl


wrote in message ups.com...

I have a question, and I would appreciate any tips on the most
efficient way to accomplish my task. I have a worksheet that has 3
pages of data when I print currently. The data is 2 narrow columns on
each page. I would like to take the data from each page, and put it
all on one page side by side ONLY FOR PRINTING purposes. I still want
the user to be able to look at the data as is, but I want the printing
to display the data on one page, with the columns from each page side
by side. I am thinking of copying and pasting the data on pages 2 and
3 to page 1 and then removing it ... but that seems a bit messy and
inefficient. Any tips/solutions would be appreciated.

Thank you,
Julia




[email protected]

Thanks for the tip!



All times are GMT +1. The time now is 11:42 PM.

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