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

Damien