+ Reply to Thread
Results 1 to 2 of 2

Excel 2007 : Right margin size modification

  1. #1
    Valued Forum Contributor
    Join Date
    06-10-2011
    Location
    London, England
    MS-Off Ver
    Excel 2010
    Posts
    341

    Right margin size modification

    Hi,

    I am working on an excel sheet with my margins set to 0.5 for everything in Landscape format, but for some reason, when I create a PDF of the worksheet, items that fit fully within the marked print area in Excel will have a much wider right handed margin, creating a sense of space on the right side.

    I tried setting the right margin to 0 to no further benefit however. Trying to ove the items I have a bit further to the right (outside the print area) moves them to a separate page in the print instead of using that blank space.

    How can I force excel to grant me use of that largish blank space on the right of the page?

    On the screenshot, the large grey area is what my full print area picture looks like. The small grey areas are footer/header

    ---

    Nevermind, I figured it out. Excel does not wrap columns, so by reducing the size of the next unused column that normally falls outside the print area, I was able to make use of the full size.
    Attached Images Attached Images
    Last edited by dip11; 06-01-2012 at 08:07 AM.

  2. #2
    Registered User
    Join Date
    04-19-2015
    Location
    San Antonio, TX (USA)
    MS-Off Ver
    2011 MAC
    Posts
    1

    Re: Excel 2007 : Right margin size modification

    I have the same problem!

    I can't seem to get the right margin to be the same as the left margin.
    When I remove the right margin (leave it at 0"), the last column will jump to the next page as I am widening a column's width even though all the columns fit inside the page.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1