+ Reply to Thread
Results 1 to 2 of 2

Thread: How to remove Page Breaks within Set Print Area

  1. #1
    Registered User
    Join Date
    09-02-2009
    Location
    Texas, USA
    MS-Off Ver
    Excel 2007
    Posts
    71

    How to remove Page Breaks within Set Print Area

    The image below shows my excel file. I set the print area, but it wants to break the print area into two different pages. How do I remove this page break so the print area prints on one page and in lanscape orientation?

    Thank you in advance

    Here is a link to the picture, img tags are not working for some reason

    http://img46.imageshack.us/img46/7519/pagebreak.jpg

  2. #2
    Forum Guru Mordred's Avatar
    Join Date
    07-06-2010
    Location
    Winnipeg, Canada
    MS-Off Ver
    2007, 2010
    Posts
    2,274

    Re: How to remove Page Breaks within Set Print Area

    Here's what I did with a table from A1:AC43. Set Print Area (you did that so no problems there). Right next to the set print area button there is a "size" button. Click on that and at the bottom you will click on "more paper sizes". Choose your paper size and click on "Fit to" 1 page(s) wide by 1 pages tall. That will condense everyting into one sheet and move out the page break.
    Please leave a message after the beep!

+ 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.2.0