SOLVED

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

@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...

Highlighted

@mathetes 

 

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

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

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

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