Forum Discussion

HDelaney's avatar
HDelaney
Copper Contributor
Nov 11, 2018

Print two areas

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.  

excel
print

1 Reply

  • Damien_Rosario's avatar
    Damien_Rosario
    Silver Contributor
    Nov 11, 2018

    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

    Damien

Resources