Share via

HELP: Can't manually adjust page breaks on page break preview screen HELP

Anonymous
2011-03-08T20:24:46+00:00

I have enabled the drop & drag feature already, so that's not the problem.  I recently switched from excel 2003 to excel 2010 and every time I go to print something and try to adjust my page breaks on page break preview, it makes the worksheet 14+ pages long when it should be 1.  I've tried the scale to fit and for some reason it keeps going back to 10%...I print a lot at work and I can't right now because I can't manually adjust my page breaks - PLEASE let me know how to do this!

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

4 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2013-12-18T16:59:29+00:00

    Hi, highlight the range to be printed, then go to page layout, print area, set print area, then print it

    2 people found this answer helpful.
    0 comments
  2. Anonymous
    2014-09-05T23:39:35+00:00

    I do not find  it helpful. its frustrating as ****! I have more to do with m y time than F%^k around trying  to adjust my Page Breaks 1-2v hours do not Hack it!!!@

    0 comments
  3. Anonymous
    2013-12-18T16:53:33+00:00

    I have the very same issue and nothing I have tried

    • copy / paste into new document
    • creating a whole new document
    • updating print driver
    • changing margins
    • changing page set up

    has worked.  Very, very frustrating.

    0 comments
  4. Anonymous
    2011-03-09T11:24:30+00:00

    You may reset page breaks in the Excel file.

    Try to Copy/paste only the data range to new sheet and then check if it helps may be it is using last used cell in the worksheet.

    0 comments