SOLVED
Home

My plant list's last column won't fit

%3CLINGO-SUB%20id%3D%22lingo-sub-538936%22%20slang%3D%22en-US%22%3EMy%20plant%20list's%20last%20column%20won't%20fit%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-538936%22%20slang%3D%22en-US%22%3E%3CP%3EI%20don't%20know%20how%20to%20get%20my%20plant%20list%20to%20fit%20when%20I%20print%20it.%20I%20tried%20choosing%20legal-size%20paper%2C%20but%20the%20last%20column%20of%20my%20list%20doesn't%20show%20on%20the%20Print%20Layout.%20If%20I%20make%20the%20text%20smaller%2C%20I%20won't%20be%20able%20to%20read%20it.%20Have%20tried%20narrow%20margins%2C%20also.%3C%2FP%3E%3CP%3EI%20(obviously)%20don't%20have%20a%20lot%20of%20knowledge%20about%20Excel.%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20515px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F112402iD27D73690CE2078E%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22Screen%20Shot%202019-05-06%20at%205.30.44%20PM.jpg%22%20title%3D%22Screen%20Shot%202019-05-06%20at%205.30.44%20PM.jpg%22%20%2F%3E%3C%2FSPAN%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%2F112404i551D65084C7627E2%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22Screen%20Shot%202019-05-06%20at%205.29.35%20PM.jpg%22%20title%3D%22Screen%20Shot%202019-05-06%20at%205.29.35%20PM.jpg%22%20%2F%3E%3C%2FSPAN%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20753px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F112403i41F7869D0F31DB81%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22Screen%20Shot%202019-05-06%20at%205.28.51%20PM.jpg%22%20title%3D%22Screen%20Shot%202019-05-06%20at%205.28.51%20PM.jpg%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-538936%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%20on%20Mac%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-539092%22%20slang%3D%22en-US%22%3ERe%3A%20My%20plant%20list's%20last%20column%20won't%20fit%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-539092%22%20slang%3D%22en-US%22%3ESelect%20your%20print%20area.%20Press%20Alt%2CP%2CR%2CC%20to%20clear%20print%20area.%20Press%20Alt%2CP%2CR%2CS%20to%20set%20print%20area.%20Press%20Alt%2CP%2CS%2CP%20to%20specify%20page%20setup%2C%20then%20Print.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-542193%22%20slang%3D%22en-US%22%3ERe%3A%20My%20plant%20list's%20last%20column%20won't%20fit%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-542193%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F280482%22%20target%3D%22_blank%22%3E%40Twifoo%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20for%20the%20reply.%20I%20should%20have%20mentioned%2C%20I%20already%20did%20that%2C%20select%20the%20print%20area%2C%20still%20doesn't%20fit.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-542213%22%20slang%3D%22en-US%22%3ERe%3A%20My%20plant%20list's%20last%20column%20won't%20fit%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-542213%22%20slang%3D%22en-US%22%3EI%20suggested%20FOUR%20tasks%20before%20you%20print.%20It%E2%80%99s%20not%20surprising%20that%20you%20didn%E2%80%99t%20achieve%20your%20desired%20result%20if%20you%20did%20only%20ONE.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-542562%22%20slang%3D%22en-US%22%3ERe%3A%20My%20plant%20list's%20last%20column%20won't%20fit%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-542562%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F280482%22%20target%3D%22_blank%22%3E%40Twifoo%3C%2FA%3E%26nbsp%3BI%20already%20did%20the%20four%20steps%2C%20which%20is%20why%20I%20stated%20that%20I%20already%20tried%20the%20Set%20Print%20Area%20which%20successfully%20set%20the%20print%20area%20that%20I%20wanted%20to%20print%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-542566%22%20slang%3D%22en-US%22%3ERe%3A%20My%20plant%20list's%20last%20column%20won't%20fit%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-542566%22%20slang%3D%22en-US%22%3ETry%20to%20check%20also%20your%20printer%20properties.%20Page%20and%20printer%20properties%20must%20coincide%3B%20otherwise%2C%20the%20print%20output%20might%20be%20different%20from%20what%20you%20set%20up%20in%20page%20layout.%3C%2FLINGO-BODY%3E
TheoThistle
Occasional Contributor

I don't know how to get my plant list to fit when I print it. I tried choosing legal-size paper, but the last column of my list doesn't show on the Print Layout. If I make the text smaller, I won't be able to read it. Have tried narrow margins, also.

I (obviously) don't have a lot of knowledge about Excel.Screen Shot 2019-05-06 at 5.30.44 PM.jpgScreen Shot 2019-05-06 at 5.29.35 PM.jpgScreen Shot 2019-05-06 at 5.28.51 PM.jpg

5 Replies
Select your print area. Press Alt,P,R,C to clear print area. Press Alt,P,R,S to set print area. Press Alt,P,S,P to specify page setup, then Print.

@Twifoo 

 

Thanks for the reply. I should have mentioned, I already did that, select the print area, still doesn't fit.

I suggested FOUR tasks before you print. It’s not surprising that you didn’t achieve your desired result if you did only ONE.

@Twifoo I already did the four steps, which is why I stated that I already tried the Set Print Area which successfully set the print area that I wanted to print

Solution
Try to check also your printer properties. Page and printer properties must coincide; otherwise, the print output might be different from what you set up in page layout.
Related Conversations
Extentions Synchronization
Deleted in Discussions on
3 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
35 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
29 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies