SOLVED
Home

Printing on legal size paper

%3CLINGO-SUB%20id%3D%22lingo-sub-927926%22%20slang%3D%22en-US%22%3EPrinting%20on%20legal%20size%20paper%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-927926%22%20slang%3D%22en-US%22%3E%3CP%3EUsing%2016.16.7%20Excel%20for%20Mac.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20set%20up%20my%20printer%20to%20use%20legal%20paper%20-%20adjusted%20tray.%3C%2FP%3E%3CP%3EExcel%20doesn't%20recognize%20legal%20size%20paper%20and%20outputs%20margins%20set%20to%20letter%20size.%3C%2FP%3E%3CP%3EI%20looked%20in%20preferences%20and%20don't%20see%20anything%20where%20I%20can%20set%20paper%20size.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHelp%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-927926%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%20on%20Mac%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-928016%22%20slang%3D%22en-US%22%3ERe%3A%20Printing%20on%20legal%20size%20paper%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-928016%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F431215%22%20target%3D%22_blank%22%3E%40Piano_Man%3C%2FA%3EOnce%20you%20go%20to%20Print%20from%20the%20main%20menu%2C%20do%20you%20see%20a%20dialog%20box%20like%20this%3F%3C%2FP%3E%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%2F139538i48B684809E7A013C%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20alt%3D%22clipboard_image_0.png%22%20title%3D%22clipboard_image_0.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3EIf%20so%2C%20you%20should%20be%20able%20to%20change%20Paper%20Size%20there%2C%20to%20%22US%20Legal%22%20...%20granted%2C%20that's%20not%20as%20satisfying%20as%20somehow%20associating%20it%20with%20the%20whole%20spreadsheet%2C%20but%20it%20does%20work...%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-929976%22%20slang%3D%22en-US%22%3ERe%3A%20Printing%20on%20legal%20size%20paper%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-929976%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F425987%22%20target%3D%22_blank%22%3E%40mathetes%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThis%20is%20my%20dialog%20box.%20Who%20knew%20that%20there%20would%20be%20such%20an%20extreme%20difference%20between%20platforms%3F%E2%80%83%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-929994%22%20slang%3D%22en-US%22%3ERe%3A%20Printing%20on%20legal%20size%20paper%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-929994%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F425987%22%20target%3D%22_blank%22%3E%40mathetes%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-930422%22%20slang%3D%22en-US%22%3ERe%3A%20Printing%20on%20legal%20size%20paper%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-930422%22%20slang%3D%22en-US%22%3EYou%20see%20that%20%22Show%20Details%22%20box%20down%20at%20the%20bottom%20of%20your%20screen%20image%3F%20Click%20on%20that.%20It%20took%20me%20a%20while%2C%20but%20I%20went%20and%20looked%20at%20mine%20and%20the%20box%20at%20the%20bottom%20was%20saying%20%22Hide%20Details%22%3CBR%20%2F%3EI%20think%20that's%20the%20difference%2C%20and%20that's%20where%20you'll%20be%20able%20to%20pick%20Legal%20size%20paper%2C%20among%20many%20many%20other%20things%20having%20to%20do%20with%20options%20on%20your%20printer.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-930637%22%20slang%3D%22en-US%22%3ERe%3A%20Printing%20on%20legal%20size%20paper%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-930637%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F425987%22%20target%3D%22_blank%22%3E%40mathetes%3C%2FA%3E%26nbsp%3BI%20just%20tried%20it%20with%20high%20hopes%20but%20the%20same%20result%3A%20Three%20columns%20print%20out%20of%20four%20(the%20widest%20one).%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-932389%22%20slang%3D%22en-US%22%3ERe%3A%20Printing%20on%20legal%20size%20paper%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-932389%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F431215%22%20target%3D%22_blank%22%3E%40Piano_Man%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESOLVED%20but%20not%20ideal.%20I%20copied%20Excel%20and%20pasted%20it%20into%20a%20Word%20document%2C%20using%20the%20same%20settings.%20After%20reducing%20column%20width%2C%20the%20text%20was%20not%20cut%20off%20and%20I%20have%20what%20I%20need.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EStrange%20how%20the%20settings%20work%20in%20Word%20but%20not%20Excel.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Piano_Man
Occasional Contributor

Using 16.16.7 Excel for Mac.

 

I set up my printer to use legal paper - adjusted tray.

Excel doesn't recognize legal size paper and outputs margins set to letter size.

I looked in preferences and don't see anything where I can set paper size.

 

Help

6 Replies

@Piano_ManOnce you go to Print from the main menu, do you see a dialog box like this?

clipboard_image_0.png

If so, you should be able to change Paper Size there, to "US Legal" ... granted, that's not as satisfying as somehow associating it with the whole spreadsheet, but it does work...

@mathetes 

 

This is my dialog box. Who knew that there would be such an extreme difference between platforms? 

You see that "Show Details" box down at the bottom of your screen image? Click on that. It took me a while, but I went and looked at mine and the box at the bottom was saying "Hide Details"
I think that's the difference, and that's where you'll be able to pick Legal size paper, among many many other things having to do with options on your printer.

@mathetes I just tried it with high hopes but the same result: Three columns print out of four (the widest one).

Solution

@Piano_Man 

SOLVED but not ideal. I copied Excel and pasted it into a Word document, using the same settings. After reducing column width, the text was not cut off and I have what I need.

 

Strange how the settings work in Word but not Excel.

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
29 Replies