How do I print 2 (widely) separated areas of a spreadsheet on to .

C

Cliff-Liverpool

How do I print out 2 separated areas of a spreadsheet on to one page?
I have highlighted the print areas, but the 2 portions want to print out on
to 2 pages
 
M

Myrna Larson

Insert a new sheet to be used just for printing.

Edit/Copy the first area, switch to the new sheet, hold down the SHIFT key and
click on Edit. Select Paste Picture Link. Repeat for the 2nd area.
 
Top