set print area

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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.
 
Back
Top