Forum Discussion
Right Margin
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.
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?
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
