+ Reply to Thread
Results 1 to 8 of 8

Excel 2007 : Print to full page

  1. #1
    Registered User
    Join Date
    03-17-2010
    Location
    md
    MS-Off Ver
    Excel 2007
    Posts
    4

    Angry Print to full page

    How can I stretch a spreadsheet to fit the page? If I try to make it one page by one page, it changes nothing. If I change the percentage, it becomes two wide...I am just trying to change the height so that it can be read on an 8.5 x 11 piece of paper.
    Attached Files Attached Files

  2. #2
    Forum Expert oldchippy's Avatar
    Join Date
    02-14-2005
    Location
    Worcester, UK
    MS-Off Ver
    Excel 2007 (Home)
    Posts
    7,099

    Re: Print to full page

    Hi,

    Go into page set-up and fit 1 wide x 1 tall and change the paper size to A4. Then drag out the borders as far as possible, but I think it will still be to small to read?
    oldchippy
    -------------


    Blessed are those who can give without remembering and take without forgetting

    If you are happy with the help you have received, please click the <--- STAR icon on the left - Thanks.

    Click here >>> Top Excel links for beginners to Experts

    Forum Rules >>>Please don't forget to read these

  3. #3
    Registered User
    Join Date
    03-17-2010
    Location
    md
    MS-Off Ver
    Excel 2007
    Posts
    4

    Angry Re: Print to full page

    That's just it, I don't have anything I can grab and pull. The only option I have is to move it.
    Last edited by shg; 03-17-2010 at 08:19 PM. Reason: deleted spurious quote

  4. #4
    Forum Guru shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    39,242

    Re: Print to full page

    Autofit the width of col A, delete col B, and set the width of the rest of the columns to 2.5.

    Then do Page Setup, set the L & R margins to as small as your printer will allow, and fit to 1 page wide by 1 page tall.

    It's small, but readable.

    Please don't quote whole posts.
    Entia non sunt multiplicanda sine necessitate

  5. #5
    Registered User
    Join Date
    03-17-2010
    Location
    md
    MS-Off Ver
    Excel 2007
    Posts
    4

    Re: Print to full page

    why is the quote function there if you're not supposed to use it??

  6. #6
    Forum Guru shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    39,242

    Re: Print to full page

    For clarity, in the case when you're replying to a post earlier in the thread -- and then you delete all but the relevant lines.

  7. #7
    Registered User
    Join Date
    03-17-2010
    Location
    md
    MS-Off Ver
    Excel 2007
    Posts
    4

    Re: Print to full page

    yeah, that's what I was doin, making sure the person knew I was talking to him...pretty self explanatory. Uh yeah, making the columns 2.5 means they don't print...any other suggestions??

  8. #8
    Forum Guru shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    39,242

    Re: Print to full page

    No, I don't.

    I did what I suggested and it worked fine for me.

    EDIT: Here's what I did.
    Attached Files Attached Files
    Last edited by shg; 03-17-2010 at 08:50 PM.

+ 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