SOLVED
Home

Setting Print Areas Not Working in Excel 2016

%3CLINGO-SUB%20id%3D%22lingo-sub-91401%22%20slang%3D%22en-US%22%3ESetting%20Print%20Areas%20Not%20Working%20in%20Excel%202016%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-91401%22%20slang%3D%22en-US%22%3E%3CP%3EI'm%20trying%20to%20establish%20print%20areas%20for%20my%20Excel%20sheet.%20I%E2%80%99ve%20done%20this%20many%20times%20before.%20I'm%20no%20expert%2C%20but%20I'm%20not%20a%20newbie%20either.%20I%20can%E2%80%99t%20get%20Excel%20to%20take%20what%20I%20input.%20No%20error%20messages%20are%20generated%2C%20but%20after%20I%20exit%2C%20Excel%20will%20revert%20to%20some%20odd%20page%20sequence%20in%20the%20print%20area%20field%20that%20makes%20no%20sense%20and%20certainly%20isn't%20what%20I%20entered.%20I%E2%80%99ve%20tried%20entering%20the%20cell%20range%20manually%20and%20creating%20using%20the%20mouse%20to%20create%20the%20print%20area.%3CBR%20%2F%3E%3CBR%20%2F%3EWhat%20am%20I%20missing%3F%3CBR%20%2F%3E%3CBR%20%2F%3EThanks.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-91401%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-262193%22%20slang%3D%22en-US%22%3ERe%3A%20Setting%20Print%20Areas%20Not%20Working%20in%20Excel%202016%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-262193%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F194633%22%20target%3D%22_blank%22%3E%40Janina%20Lear%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECheck%20the%202%20column%20width%20exceeding%20paper%20size.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAnd%20Maker%20sure%20that%20Scale%20is%20100%25.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-253164%22%20slang%3D%22en-US%22%3ERe%3A%20Setting%20Print%20Areas%20Not%20Working%20in%20Excel%202016%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-253164%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20having%20the%20same%20issue.%20I%20have%20cleared%20the%20set%20print%20area%2C%20tried%20a%20different%20computer%20and%20dame%20thing.%20I%20have%20selected%203%20columns%20but%20it%20is%20only%20wanting%20to%20print%202.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAny%20ideas%20why%20it%20would%20do%20this.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EJanina%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-92340%22%20slang%3D%22en-US%22%3ERe%3A%20Setting%20Print%20Areas%20Not%20Working%20in%20Excel%202016%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-92340%22%20slang%3D%22en-US%22%3EIt%20worked%20perfectly!%20Thank%20you.%20I%20can't%20imagine%20why%20this%20would%20be%20necessary%2C%20but%20it%20definitely%20solved%20my%20problem.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-91927%22%20slang%3D%22en-US%22%3ERe%3A%20Setting%20Print%20Areas%20Not%20Working%20in%20Excel%202016%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-91927%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%2F69295%22%20target%3D%22_blank%22%3E%40Scott%20Cox%3C%2FA%3E%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F18007i71A6B05E4E0068FF%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22Untitled2.png%22%20title%3D%22Untitled2.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-91482%22%20slang%3D%22en-US%22%3ERe%3A%20Setting%20Print%20Areas%20Not%20Working%20in%20Excel%202016%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-91482%22%20slang%3D%22en-US%22%3EHow%20do%20I%20do%20that%2C%20%22clear%20and%20set%3F%22%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-91433%22%20slang%3D%22en-US%22%3ERe%3A%20Setting%20Print%20Areas%20Not%20Working%20in%20Excel%202016%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-91433%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%2F69295%22%20target%3D%22_blank%22%3E%40Scott%20Cox%3C%2FA%3E%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EDid%20you%20tried%20clear%20the%20print%20area%20and%20set%20the%20print%20area.%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-500513%22%20slang%3D%22en-US%22%3ERe%3A%20Setting%20Print%20Areas%20Not%20Working%20in%20Excel%202016%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-500513%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F53299%22%20target%3D%22_blank%22%3E%40Logaraj%20Sekar%3C%2FA%3E%26nbsp%3B%20%26nbsp%3BDid%20that%20didn't%20help%3C%2FP%3E%3C%2FLINGO-BODY%3E
Scott Cox
Contributor

I'm trying to establish print areas for my Excel sheet. I’ve done this many times before. I'm no expert, but I'm not a newbie either. I can’t get Excel to take what I input. No error messages are generated, but after I exit, Excel will revert to some odd page sequence in the print area field that makes no sense and certainly isn't what I entered. I’ve tried entering the cell range manually and creating using the mouse to create the print area.

What am I missing?

Thanks.

7 Replies

Hi @Scott Cox,

 

Did you tried clear the print area and set the print area.?

How do I do that, "clear and set?"
It worked perfectly! Thank you. I can't imagine why this would be necessary, but it definitely solved my problem.

I am having the same issue. I have cleared the set print area, tried a different computer and dame thing. I have selected 3 columns but it is only wanting to print 2.

 

Any ideas why it would do this.

 

Janina

@Janina Lear

 

Check the 2 column width exceeding paper size.

 

And Maker sure that Scale is 100%.

@Logaraj Sekar   Did that didn't help