SOLVED

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

Hi 

 

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

 

image.png

Highlighted

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?

Highlighted
Best Response confirmed by ok1wire (New Contributor)
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