+ Reply to Thread
Results 1 to 2 of 2

How to remove Page Breaks within Set Print Area

  1. #1
    Forum Contributor
    Join Date
    09-02-2009
    Location
    Texas, USA
    MS-Off Ver
    Excel 2007
    Posts
    110

    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

    \1

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

    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.
    If you're happy with someone's help, click that little star at the bottom left of their post to give them Reps.

    ---Keep on Coding in the Free World---

+ 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