Thread: set print area
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default 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