SOLVED
Home

Setting Print Areas Not Working in Excel 2016

%3CLINGO-SUB%20id%3D%22lingo-sub-311191%22%20slang%3D%22en-US%22%3ESetting%20Print%20Areas%20Not%20Working%20in%20Excel%202016%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-311191%22%20slang%3D%22en-US%22%3E%3CP%3E%26nbsp%3BFinancial%20spreadsheet.%20Each%20month%20has%205%20columns.%20Each%20month%20I%20print%206%20columns.%20December%20will%20only%20print%20the%206%20columns%20on%20two%20pages.%20All%20other%20months%20print%206%20columns%20on%20one%20page.%20All%20other%20spreadsheets%20print%20correctly.%3C%2FP%3E%3CP%3EHave%20changed%20the%20December%20font%20size%20and%20column%20width........Still%20prints%20on%20two%20pages%20with%20column%206%20on%20the%20first%20page%20and%201-5%20on%20the%20second%20page.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-311191%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%20printing%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-312153%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-312153%22%20slang%3D%22en-US%22%3EGreat%2C%3CBR%20%2F%3E%3CBR%20%2F%3ESometimes%20the%20size%20of%20the%20page%20just%20happens%20to%20fit%2C%20if%20the%20columns%20are%20just%20slightly%20wider%20on%20the%20December%20page%20the%20column%20will%20drop%20onto%20a%20second%20printout.%3CBR%20%2F%3E%3CBR%20%2F%3ESetting%20the%20width%20and%20height%20will%20utilise%20those%20extra%20pages%20if%20required.%20I%20often%20set%20Width%20to%201%20and%20height%20to%20automatic%20so%20extra%20pages%20are%20printed%20for%20long%20reports.%3CBR%20%2F%3E%3CBR%20%2F%3EWould%20you%20mind%20marking%20the%20solution%20as%20Best%20Response%20if%20it%20helped.%20Thanks%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-311952%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-311952%22%20slang%3D%22en-US%22%3E%3CP%3EHeight%20and%20Width%20were%20both%20set%20on%20%3CEM%3EAutomatic%26nbsp%3B%3C%2FEM%3Ewith%20a%20scale%20of%2010%25.%20I%20reset%20both%20to%26nbsp%3B%3CEM%3E1%20Page.%20%3C%2FEM%3EThe%206%20columns%20all%20printed%20on%20one%20page.%20%3CSTRONG%3EHooray!!!%3C%2FSTRONG%3E%20Thanks%20for%20the%20Voodoo.%3C%2FP%3E%3CP%3EQuestions%3A%3C%2FP%3E%3CP%3E1.%20Why%20did%20every%20other%20set%20of%206%20columns%20set%20in%26nbsp%3B%3CEM%3EAutomatic%26nbsp%3B%3C%2FEM%3Eprint%20properly%3F%3C%2FP%3E%3CP%3E2.%20What%20would%20have%20happened%20if%20I%20had%20set%20H%20and%20W%20to%203%20or%204%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-311219%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-311219%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EIs%20your%20Page%20Set%20up%20set%20to%201%20page%20wide%20by%201%20page%20tall%3F%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F64988iE5E6990573150CC9%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22image.png%22%20title%3D%22image.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
ok1wire
New Contributor

 Financial spreadsheet. Each month has 5 columns. Each month I print 6 columns. December will only print the 6 columns on two pages. All other months print 6 columns on one page. All other spreadsheets print correctly.

Have changed the December font size and column width........Still prints on two pages with column 6 on the first page and 1-5 on the second page.

3 Replies

Hi 

 

Is your Page Set up set to 1 page wide by 1 page tall?

 

image.png

Height and Width were both set on Automatic with a scale of 10%. I reset both to 1 Page. The 6 columns all printed on one page. Hooray!!! Thanks for the Voodoo.

Questions:

1. Why did every other set of 6 columns set in Automatic print properly?

2. What would have happened if I had set H and W to 3 or 4?

Solution
Great,

Sometimes the size of the page just happens to fit, if the columns are just slightly wider on the December page the column will drop onto a second printout.

Setting the width and height will utilise those extra pages if required. I often set Width to 1 and height to automatic so extra pages are printed for long reports.

Would you mind marking the solution as Best Response if it helped. Thanks
Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
21 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies