Right Margin

%3CLINGO-SUB%20id%3D%22lingo-sub-2597238%22%20slang%3D%22en-US%22%3ERight%20Margin%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2597238%22%20slang%3D%22en-US%22%3E%3CP%3EHOW%20do%20I%20fix%20the%20right%20margin%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20both%20left%20and%20right%20margins%20set%20at%20zero.%3C%2FP%3E%3CP%3EI%20have%20it%20to%20fit%20one%20page.%3C%2FP%3E%3CP%3ENo%20matter%20what%20I%20do%2C%20the%20right%20margin%20still%20remains%20about%20one%20inch%20from%20the%20right%20side.%3C%2FP%3E%3CP%3EHow%20can%20I%20fix%20this%3F%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2597238%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2597819%22%20slang%3D%22en-US%22%3ERe%3A%20Right%20Margin%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2597819%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1117653%22%20target%3D%22_blank%22%3E%40TeresaTAO%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThat's%20not%20an%20image%20of%20the%20printed%20output...%20But%20in%20any%20event%2C%20that%20picture%20adds%20nothing%20to%20understanding%20of%20the%20difficulty%2C%20since%20it%20was%20pretty%20clear%20to%20begin%20with.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIt%20might%20be%20more%20helpful%20if%20you%20could%3A%3C%2FP%3E%3CP%20class%3D%22lia-indent-padding-left-30px%22%3E(a)%20attach%20%3CU%3E%3CEM%3Eimages%3C%2FEM%3E%20of%20the%20printer%20settings%3C%2FU%3E%20when%20you%20print%20in%20portrait%20(apparently%20successfully%20having%20a%20right%20margin%20of%200)%3C%2FP%3E%3CP%20class%3D%22lia-indent-padding-left-30px%22%3E(b)%20attach%20%3CU%3E%3CEM%3Eimages%3C%2FEM%3E%20of%20the%20printer%20settings%3C%2FU%3E%20when%20you%20print%20in%20landscape%20(unsuccessfully)%3C%2FP%3E%3CP%20class%3D%22lia-indent-padding-left-30px%22%3E(c)%20attach%20the%20%3CU%3Eactual%20(%3CEM%3E%3CSTRONG%3ENOT%3C%2FSTRONG%3E%20an%20image%3C%2FEM%3E)%20spreadsheet%3C%2FU%3E%2C%20just%20so%20long%20as%20it%20contains%20no%20confidential%20info%2C%20so%20I%20or%20someone%20else%20can%20see%20what%20happens%20on%20our%20own%20computers%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2597375%22%20slang%3D%22en-US%22%3ERe%3A%20Right%20Margin%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2597375%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%3EI%20give%20up.%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3CP%3EThis%20is%20a%20pix%20of%20my%20problem.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2597358%22%20slang%3D%22en-US%22%3ERe%3A%20Right%20Margin%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2597358%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1117653%22%20target%3D%22_blank%22%3E%40TeresaTAO%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%20class%3D%22lia-indent-padding-left-30px%22%3E%3CEM%3EHUM%2C%20how%20would%20I%20check%20to%20see%20if%20it%20is%20a%20printer%20problem%20vs.%20Excel%20problem.%3C%2FEM%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3EOne%20way%20would%20be%20by%20seeing%20what%20happens%20in%20another%20software%20package%20like%20Word%3B%20that's%20why%20I%20asked%20that.%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%20class%3D%22lia-indent-padding-left-30px%22%3E%3CEM%3EMy%20spreadsheet%20is%2043%20columns%20wide.%3CBR%20%2F%3EI%20just%20checked%20on%20a%203%20column%20wide%20spreadsheet%20in%20the%20same%20file%20and%20I%20do%20NOT%20have%20this%20problem.%3CBR%20%2F%3ESO....does%20it%20have%20something%20to%20do%20with%20the%20multiple%20columns%3F%3F%3F%3F%3F%3F%3C%2FEM%3E%3C%2FP%3E%3CP%20class%3D%22lia-indent-padding-left-30px%22%3E%3CEM%3EPortrait...margins%20fine%20(zero%2C%20horizontally%20centered...beautiful)%3CBR%20%2F%3EI%20switch%20back%20to%20Landscape......%20one%20inch%20right%20margin%20shows%20back%20up.%3C%2FEM%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3ECertainly%20could%20have%20something%20to%20do%20with%20that%20many%20columns.%20I'll%20assume%20some%2Fall%20of%20them%20are%20quite%20narrow%2C%20but%20nevertheless%2C%20that's%20a%20LOT%20of%20columns.%20Are%20you%20saying%20that%20all%20the%20columns%20fit%20on%20the%20portrait%20mode%3F%20(Perhaps%20illegibly%2C%20but%20all%20fit%3F)%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3EBut%20you've%20also%20added%20in%20here%20the%20portrait%20vs%20landscape%20setting.%20Which%20really%20means%20(physically)%20when%20in%20landscape%20it's%20the%20bottom%20margin%20of%20the%20paper%20as%20it%20comes%20through%20the%20printer%20(it's%20the%20right%20margin%20when%20viewed%20as%20a%20human%20looks%20at%20it%2C%20but%20bottom%20so%20far%20as%20the%20printer%20is%20concerned)%2C%20and%20it%20does%20seem%20possible%20that%20this%26nbsp%3Bcould%20be%20a%20factor.%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3EAre%20you%20aware%20you%20can%20ask%20Excel--in%20printer%20settings--to%20repeat%20row%20and%26nbsp%3B%3C%2FSPAN%3Ecolumn%20headings%20on%20the%20top%20and%20left%20of%20the%20page....which%20would%20allow%20you%20to%20print%20on%20multiple%20pages%20and%20show%20your%20data%20in%20larger%20font%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2597310%22%20slang%3D%22en-US%22%3ERe%3A%20Right%20Margin%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2597310%22%20slang%3D%22en-US%22%3EPortrait...margins%20fine%20(zero%2C%20horizontally%20centered...beautiful)%3CBR%20%2F%3EI%20switch%20back%20to%20Landscape......%20one%20inch%20right%20margin%20shows%20back%20up.%3CBR%20%2F%3E%3CBR%20%2F%3EWhy%3F%3F%3F%3CBR%20%2F%3E%3CBR%20%2F%3EAnyone%20have%20any%20ideas%3F%3F%3F%3F%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2597275%22%20slang%3D%22en-US%22%3ERe%3A%20Right%20Margin%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2597275%22%20slang%3D%22en-US%22%3EMy%20spreadsheet%20is%2043%20columns%20wide.%3CBR%20%2F%3EI%20just%20checked%20on%20a%203%20column%20wide%20spreadsheet%20in%20the%20same%20file%20and%20I%20do%20NOT%20have%20this%20problem.%3CBR%20%2F%3ESO....does%20it%20have%20something%20to%20do%20with%20the%20multiple%20columns%3F%3F%3F%3F%3F%3F%3CBR%20%2F%3E%3CBR%20%2F%3ETHANK%20YOU%20for%20your%20insight%2Fhelp!%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2597273%22%20slang%3D%22en-US%22%3ERe%3A%20Right%20Margin%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2597273%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%3EI%20don't%20know%20about%20Word.%26nbsp%3B%20I%20only%20use%20Excel.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20my%20data%20as%20%22set%20print%22%20for%20area%20I%20want%20to%20print.%3C%2FP%3E%3CP%3EI%20have%20page%20set%20as%20one%20page%20tall%20and%20one%20page%20wide.%3C%2FP%3E%3CP%3EI%20can%20see%20right%20margin%20line%20in%20print%20preview....it%20just%20won't%20move%20for%20me.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECorrect%20on%20printer.%26nbsp%3B%20I%20believe%20my%20printer%20is%20a%20Cannon%20all-in-one.%3C%2FP%3E%3CP%3EHUM%2C%20how%20would%20I%20check%20to%20see%20if%20it%20is%20a%20printer%20problem%20vs.%20Excel%20problem.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2597262%22%20slang%3D%22en-US%22%3ERe%3A%20Right%20Margin%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2597262%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1117653%22%20target%3D%22_blank%22%3E%40TeresaTAO%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThat%20could%20be%20a%20function%20of%20your%20printer%20too.%20So%20let%20me%20ask%20this%3A%20are%20you%20able%20to%20accomplish%20zero%20margins%20right%20and%20left%20in%20other%20software%20packages%20(e.g.%2C%20Word)%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIt's%20also%20possible%20to%20reduce%20the%20size%20of%20the%20printed%20area%2C%20assuming%20you're%20using%20a%20laser%20or%20inkjet%20printer%2C%20so%20that%20it%20prints%20on%20one%20page%20with%20a%20margin%20still%20there.%20Using%20the%20%22Scale%20to%20fit%22%20option%20on%20the%20print%20dialog%20screen.%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22mathetes_0-1627829724773.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F299749i457E2E23FC5DC636%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22mathetes_0-1627829724773.png%22%20alt%3D%22mathetes_0-1627829724773.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Contributor

HOW do I fix the right margin?

 

I have both left and right margins set at zero.

I have it to fit one page.

No matter what I do, the right margin still remains about one inch from the right side.

How can I fix this??

7 Replies

@TeresaTAO 

 

That could be a function of your printer too. So let me ask this: are you able to accomplish zero margins right and left in other software packages (e.g., Word)?

 

It's also possible to reduce the size of the printed area, assuming you're using a laser or inkjet printer, so that it prints on one page with a margin still there. Using the "Scale to fit" option on the print dialog screen.

mathetes_0-1627829724773.png

 

@mathetes 

 

I don't know about Word.  I only use Excel. 

 

I have my data as "set print" for area I want to print.

I have page set as one page tall and one page wide.

I can see right margin line in print preview....it just won't move for me.

 

Correct on printer.  I believe my printer is a Cannon all-in-one.

HUM, how would I check to see if it is a printer problem vs. Excel problem.

 

 

My spreadsheet is 43 columns wide.
I just checked on a 3 column wide spreadsheet in the same file and I do NOT have this problem.
SO....does it have something to do with the multiple columns??????

THANK YOU for your insight/help!
Portrait...margins fine (zero, horizontally centered...beautiful)
I switch back to Landscape...... one inch right margin shows back up.

Why???

Anyone have any ideas????

@TeresaTAO 

HUM, how would I check to see if it is a printer problem vs. Excel problem.

 

One way would be by seeing what happens in another software package like Word; that's why I asked that.

 

My spreadsheet is 43 columns wide.
I just checked on a 3 column wide spreadsheet in the same file and I do NOT have this problem.
SO....does it have something to do with the multiple columns??????

Portrait...margins fine (zero, horizontally centered...beautiful)
I switch back to Landscape...... one inch right margin shows back up.

 

Certainly could have something to do with that many columns. I'll assume some/all of them are quite narrow, but nevertheless, that's a LOT of columns. Are you saying that all the columns fit on the portrait mode? (Perhaps illegibly, but all fit?)

 

But you've also added in here the portrait vs landscape setting. Which really means (physically) when in landscape it's the bottom margin of the paper as it comes through the printer (it's the right margin when viewed as a human looks at it, but bottom so far as the printer is concerned), and it does seem possible that this could be a factor.

 

Are you aware you can ask Excel--in printer settings--to repeat row and column headings on the top and left of the page....which would allow you to print on multiple pages and show your data in larger font?

@mathetes 

 

I give up.  

This is a pix of my problem.

@TeresaTAO 

 

That's not an image of the printed output... But in any event, that picture adds nothing to understanding of the difficulty, since it was pretty clear to begin with.

 

It might be more helpful if you could:

(a) attach images of the printer settings when you print in portrait (apparently successfully having a right margin of 0)

(b) attach images of the printer settings when you print in landscape (unsuccessfully)

(c) attach the actual (NOT an image) spreadsheet, just so long as it contains no confidential info, so I or someone else can see what happens on our own computers