How to Control Display of Page Breaks in Excel 2010

There are two types of page breaks that can appear in your worksheet in Excel 2010. Those would be Manual and Automatic.

As you know, you insert page breaks manually by clicking on the Breaks tool in the Page Layout tab in the Page Setup group on your Ribbon.


Automatic page breaks are those that are calculated by Excel based on different settings (i.e., page size, margins, cell size, etc.).

You can also control whether your page breaks are displayed on your screen (with dashed lines).

Follow the steps below to learn how:

  1. Display the File tab of your Ribbon and Click Options.
  2. Click Advanced on the left-hand side.
  3. Under Display options for this worksheet, use the drop-down list at the top of the section to indicate which worksheet you want to affect.


  1. Set the Show Page Breaks check box to your liking. If selected, then Excel will display page breaks on-screen for the designated worksheet.
  2. Click OK.


Posted in:
About the Author

Carol Bratt

Carol holds A+, MCP, and MOS computer certifications and is the resident DCT Office expert. She trains the staffs of small law firms in the use of Microsoft Office applications and has authored many books covering Microsoft Office as well as written articles for Infopackets, TechnoLawyer, and Digital Harbor. For more Microsoft Office tips visit Carol's Corner Office or follow Carol on FaceBook and Twitter.