Share via

Excel Files have page breaks added

Anonymous
2010-06-09T17:50:10+00:00

Excel has suddenly started showing page breaks all documents on my PC. Even documents that have not been opened for ages are showing them when opened (to check).

I am not aware that anything has changed to cause this although going into Advanced under Excel Options the tick box for show page breaks is greyed out.

All files are affected although opening them on another computer shows they have not changed - I guess I must have done something to the setup the original machine, by what?

Please can anyone suggest anything.

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

Answer accepted by question author

  1. Anonymous
    2010-06-09T17:57:20+00:00

    Look at the Status bar (very bottom of Excel window); to the right just before the 'zoomer' atr there icons. Let the mouse hover over each to see they are: Normal View, Page Layout and Page Break Preview. Somehow you clicked the last icon recently. Just click the fist one and all will be well

    best wishes

    people.stfx.ca/bliengme

    8 people found this answer helpful.
    0 comments

Answer accepted by question author

  1. Anonymous
    2010-06-09T18:12:35+00:00

    Hi,

    First, (your spelling is as bad as mine Bernard) make sure you are in Normal view as Bernard pointed out.

    1. To turn off page breaks that are displayed choose Office Button, Excel Options, Advanced, and in the group Display options for this worksheet, uncheck Show page breaks.  If this is applies to many sheets in the workbook, select all the sheets first and then do the command.
    2. If they are manual page breaks then you can choose Page Layout, Breaks, Remove Page breaks
    3. If they appear even in a new workbook, then they have been set in the default workbook, usually in the XLStart folder.  You would need to open that file, usually called Book.xlt and reset the page breaks and save the file.

    If this answer solves your problem, please check Mark as Answered. If this answer helps, please click the Vote as Helpful button. Cheers, Shane Devenshire

    0 comments

Answer accepted by question author

  1. Anonymous
    2010-06-09T18:05:44+00:00

    Bernard

    Thanks for this suggestion.

    Further investigation shows that somehow the printer setting had changed to my label printer resulting in the reduced page sizes and imposed page breaks. I feel rather foolish at this but thanks again.

    0 comments

4 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2010-08-16T22:54:37+00:00

    This is not the answer. When you are in page view the problem still is there.

    1 person found this answer helpful.
    0 comments
  2. Anonymous
    2010-06-10T12:07:40+00:00

    Hi Shane,

    One reason I might swtich over to using the Bridge is the lack of spell check in this forum interface. My spelling is poor but my typing is even worse!

    best wishes

    Bernard

    people.stfx.ca/bliengme

    0 comments