Forum Discussion
Right Margin
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.
There is still a forced margin on the right (in Landscape) and bottom (in Portrait).
It has nothing to do with margins or print areas, there is a Formatted BLOCK disallowing us to utilize the entire page in all Microsoft applications on the A4 page. "Letter" size does not appear to have this block.
- Your posting is something of a non sequitur in this thread. What's the context? Is there a question?
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?
- 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????
