1. Computer problem? Tech Support Guy is completely free -- paid for by advertisers and donations. Click here to join today! If you're new to Tech Support Guy, we highly recommend that you visit our Guide for New Members.

Excel 2010, every cell has a page break

Discussion in 'Business Applications' started by holymoly, May 30, 2012.

Thread Status:
Not open for further replies.
Advertisement
  1. holymoly

    holymoly Thread Starter

    Joined:
    Jun 21, 2003
    Messages:
    635
    When doing a Page Break Preview, there a a page break for all cells, so the print option is set to print a page per cell.

    Using Page Layout --> Remove Page Break (or alternatively Reset All Page Breaks) does not solve the issue.

    One solution is to change the Size from 8.5 X 11 to 8.5 X 14, but I do not wish to print legal size.

    A Google search, typically returned the Remove Page Break solution.


    Any solutions?
     
  2. WendyM

    WendyM Trusted Advisor

    Joined:
    Jun 27, 2003
    Messages:
    4,032
    Is a print area set? Try going to the Page Layout tab and clearing the print area.
     
  3. holymoly

    holymoly Thread Starter

    Joined:
    Jun 21, 2003
    Messages:
    635
    Thanks Wendy,

    I tinkered around with the Clear print area and it cleared all the page breaks for all the cells
    and I can now print on letter size.
     
  4. WendyM

    WendyM Trusted Advisor

    Joined:
    Jun 27, 2003
    Messages:
    4,032
    Great, glad it worked. (y)
     
  5. holymoly

    holymoly Thread Starter

    Joined:
    Jun 21, 2003
    Messages:
    635
    It did clear all the page breaks, but upon Print Preview or printing, all the page breaks reverted,

    Back to the drawing board. :(
     
  6. WendyM

    WendyM Trusted Advisor

    Joined:
    Jun 27, 2003
    Messages:
    4,032
    Do you have more than one printer installed? If so, try switching to another printer and then look at it again. Does it still have the page breaks?
     
  7. Garf13LD

    Garf13LD

    Joined:
    Apr 17, 2012
    Messages:
    455
    1. Page Layout > Breaks > Reset All Page Breaks
    2. Clear all print areas
    3. Check your margins
    4. All else fails, upload the file.
     
  8. holymoly

    holymoly Thread Starter

    Joined:
    Jun 21, 2003
    Messages:
    635
    I remember someone had a page break issue and resolved when in page setup, the print was set to fit page.

    Checking my settings, it was to fit one page vertically and horizontally. Trying to uncheck the fit one page, returned an error.

    Bizarre.
     
  9. WendyM

    WendyM Trusted Advisor

    Joined:
    Jun 27, 2003
    Messages:
    4,032
    What error do you get? Have you tried changing to a different printer if you have one available?
     
  10. holymoly

    holymoly Thread Starter

    Joined:
    Jun 21, 2003
    Messages:
    635
    Looks like its a printer issue, driver problem?

    I did a preview in another printer, and the range displayed was correct.

    Then I reverted to the preview with the problem printer, and the range stayed the same, no separate page for each cell in the range, or 3817 pages to print.

    Strange
     
  11. WendyM

    WendyM Trusted Advisor

    Joined:
    Jun 27, 2003
    Messages:
    4,032
    Yep, that's my suspicion. I wouldn't be surprised if once you reboot, you're back to the same problem on the original printer. I'd try updating your drivers for the problem printer and printing to the alternate one in the meantime.
     
  12. Sponsor

As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 733,556 other people just like you!

Loading...
Thread Status:
Not open for further replies.

Short URL to this thread: https://techguy.org/1055194