Home

Print two areas

%3CLINGO-SUB%20id%3D%22lingo-sub-285112%22%20slang%3D%22en-US%22%3EPrint%20two%20areas%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-285112%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20a%20relatively%20novice%20user%20of%20Excel.%26nbsp%3B%20There%20are%20two%20areas%20on%20a%20worksheet%20I%20would%20like%20to%20print.%26nbsp%3B%20On%20A1%3AJ58%20I%20would%20like%20printed%20on%20the%20front%20of%20paper%20and%20K10%3AM40%20printed%20on%20the%20other%20side%20of%20the%20paper.%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-285112%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3Eprint%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-285128%22%20slang%3D%22en-US%22%3ERe%3A%20Print%20two%20areas%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-285128%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F240929%22%20target%3D%22_blank%22%3E%40Hugh%20Delaney%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ETry%20selecting%20the%20A1%20to%20J58%20and%20then%20press%20Ctrl%20and%20select%20K10%20to%20M40.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThen%20go%20to%20the%20Page%20Layout%20menu%20tab%20%26gt%3B%20Print%20Area%20%26gt%3B%20Set%20Print%20Area.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EYou%20should%20see%20AQ1%3AJ58%20on%20page%201%2C%20and%20K10%3AM40%20on%20page%202%20(make%20sure%20to%20choose%20duplex%20printing%20if%20you%20want%20it%20on%20both%20sides).%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ELet%20me%20know%20if%20this%20helps%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECheers%20and%20best%20wishes%3C%2FP%3E%3CP%3EDamien%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Hugh Delaney
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

Related Conversations
Printing of PDF's broken in DEV build 80.0.345.0
ToMMeR in Enterprise on
1 Replies
Excel Print Preview not matching the actual printed document
Gano1224 in Excel on
12 Replies
Printing Forms - questions view
Deleted in Microsoft Forms on
3 Replies
Printing based on Cell value - VBA???
Justin_L in Excel on
4 Replies