Excel Page Break Preview Tips

Have you seen this? When you open an Excel file, or switch to a different worksheet, there’s a large “Page 1” watermark in the middle of the sheet.

If you’re familiar with this, maybe you can answer my question, further down, about using it in Excel 2013. If not, keep reading!

pagebreakpreview

That “Page 1” doesn’t appear when you print the sheet, but if you’ve never seen it before, it can be annoying. How did it get there, and how can you get rid of it?

Page Break Preview

That page number is a sign that you are in Page Break Preview, and you can turn that setting off and on.

To go back to the regular worksheet view:

  • On the Ribbon, click the View tab
  • At the left, click the Normal View command.

normalviewribbon

Another way to switch between views is to use the small icons at the bottom right of the Excel window:

normalview

Using Page Break Preview

Don’t give up on Page Break Preview though, just because it has that annoying “Page 1” in the middle of it. It’s a great way to see how the printed pages will look, before you actually print them.

It shows all the automatic page breaks, as dashed blue lines. If you don’t like the position that an automatic page break falls, you can drag it to a new location, where it becomes a manual page break.

pagebreakpreview02

I had problems dragging the dashed line in Excel 2013 – the pointer and the grey line didn’t stay in the same place. Maybe it’s just my computer though – if you try it, please let me know if you see the same thing.

pagebreakpreview03

Watch the Page Break Preview Video

To see the steps for switching between view, and adjusting the page breaks, please watch this short video tutorial.

Page Break Preview

________________

5 Responses

  1. The cursor lag does not happen for me Debra.

  2. Ken Puls says:

    Hi Debra,

    Funny enough, I was just cursing that problem the other day here. Excel 2013 (64 bit) on Windows 8.

  3. Dave Wenta says:

    Got the same thing. They just show up. Have no ideas when or how. Excel 2013, Windows 8, 64 bit. I, too, thought I was the only one.

Leave a Reply to Debra Dalgleish Cancel reply

Your email address will not be published. Required fields are marked *