Print two areas

Occasional Visitor

I am a relatively novice user of Excel.  There are two areas on a worksheet I would like to print.  On A1:J58 I would like printed on the front of paper and K10:M40 printed on the other side of the paper.  

1 Reply

Hi @HDelaney


Try selecting the A1 to J58 and then press Ctrl and select K10 to M40.


Then go to the Page Layout menu tab > Print Area > Set Print Area.


You should see AQ1:J58 on page 1, and K10:M40 on page 2 (make sure to choose duplex printing if you want it on both sides).


Let me know if this helps?


Cheers and best wishes