Print two areas

Highlighted
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
Highlighted

Hi @Hugh Delaney

 

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

Damien