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

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
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies