ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   set print area (https://www.excelbanter.com/excel-discussion-misc-queries/139187-set-print-area.html)

emel

set print area
 
How do I select a column and skip to the next column and set the print area
so that the 2 columns should print side by side and not on 2 different pages?

Don Guillett

set print area
 
Hide the intervening columns?

--
Don Guillett
SalesAid Software

"emel" wrote in message
...
How do I select a column and skip to the next column and set the print
area
so that the 2 columns should print side by side and not on 2 different
pages?



Dave Peterson

set print area
 
One way is to hide (temporarily) the columns that separate the columns to print.

Another way is to "take a picture" of each range and paste those pictures in a
different worksheet and print that worksheet.

Insert a new worksheet
Select the first range
edit|copy
Go to A1 of that new worksheet
shift-edit-paste picture link

Do the same with the second range, but paste to the right of the first pasted
picture.



emel wrote:

How do I select a column and skip to the next column and set the print area
so that the 2 columns should print side by side and not on 2 different pages?


--

Dave Peterson


All times are GMT +1. The time now is 10:20 AM.

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