+ Reply to Thread
Results 1 to 11 of 11

Set print area to end of text on page

  1. #1
    Forum Contributor
    Join Date
    06-17-2007
    Posts
    113

    Set print area to end of text on page

    I have a problem when I want to print, it will only print a set area. How to I make it print everything, so it prints everything till the last letter on the page?
    I tried selecting the print area, but once i add more text it goes out again.
    Last edited by oldchippy; 08-09-2009 at 05:08 AM.

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

    Re: Set print area to end of text on page

    Hi,

    Can you widen the columns and/or margins of the page?

    What font are you using, try changing to Times Roman or Ariel
    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
    Forum Guru
    Join Date
    08-05-2004
    Location
    NJ
    MS-Off Ver
    365
    Posts
    13,578

    Re: Set print area to end of text on page

    It sounds like you are not using "Wrap Text" and thus the text spills over to other columns in Excel. Excel has no way of knowing how far over the text is going. To Excel, everything is in your first cell.

    As Chippy suggested, make your cell width, the width of the page and then go to Format Cell>Alignment and choose Wrap Text. Will that work for you?
    ChemistB
    My 2?

    substitute commas with semi-colons if your region settings requires
    Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
    If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)

    Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble

  4. #4
    Forum Contributor
    Join Date
    06-17-2007
    Posts
    113

    Re: Set print area to end of text on page

    hmmm I tried but doesnt quiet seem to work. I attached an edited version of the file (like hid the contact details for privacy issues).
    Could you have a look and let me know how I can fix it.

    Thanks
    Attached Files Attached Files

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

    Re: Set print area to end of text on page

    Hi,

    If you want to print it all on one page, it will be a bit squashed, but to show you do this select B1:G66, click Page Layout tab > Print Area > Set Print Area, then print it.

    You may have to re-adjust the text if you want to get everything on one page so that you can read it.

    Post back if you want more help?

  6. #6
    Forum Guru
    Join Date
    08-05-2004
    Location
    NJ
    MS-Off Ver
    365
    Posts
    13,578

    Re: Set print area to end of text on page

    If you delete your print area, it will print everything. You have it set up to print everything on 1 page. If that's not important, reset that to 100%, add a header with page # of # and maybe rows to repeat at top 1:3. It then becomes 2 pages long with your title and quote on both pages. Will that work for you?

  7. #7
    Forum Expert contaminated's Avatar
    Join Date
    05-07-2009
    Location
    Baku, Azerbaijan
    MS-Off Ver
    Excel 2013
    Posts
    1,430

    Re: Set print area to end of text on page

    Hi
    Every time you set print area, you create a named range Print_Area.
    Press Ctrl+F3 you'll see what I'm talikn' about.

    Lets say it refers to range C3:O22
    So if u add a values in lower rows it wouldn't print 'em until u change references.

    U can use dynamical function like
    Please Login or Register  to view this content.
    in my example.

    See attached file pls...
    Attached Files Attached Files
    Last edited by contaminated; 08-07-2009 at 04:12 PM.
    Люди, питающие благие намерения, как раз и становятся чудовищами.

    Regards, ?Born in USSR?
    Vusal M Dadashev

    Baku, Azerbaijan

  8. #8
    Forum Contributor
    Join Date
    06-17-2007
    Posts
    113

    Re: Set print area to end of text on page

    Ok thanks ChemistB, it worked. But something happened now, theres a 3rd page that is blank that it wants to print. How do i get rid of it?
    Last edited by philmetz; 08-07-2009 at 09:39 PM.

  9. #9
    Forum Contributor
    Join Date
    06-17-2007
    Posts
    113

    Re: Set print area to end of text on page

    Any idea why im getting this extra page? I have cleared the print area but still get it.

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

    Re: Set print area to end of text on page

    Hi,

    When you come out of Print Preview you should see dashed lines on the worksheet that represent the size of each page, if you scroll down to the third page (that has nothing on it) and select all the rows for that page, then right click and press delete - you have now deleted that 3rd page from the print area - OK?

  11. #11
    Forum Contributor
    Join Date
    06-17-2007
    Posts
    113

    Re: Set print area to end of text on page

    Ah nevermind, I went to page break preview and there was a page to the right. deleted that. works fine now. thanks anyway.
    Last edited by philmetz; 08-08-2009 at 11:17 PM. Reason: solved

+ 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