How to Hide Page Breaks in Excel 2010

Occasionally your Microsoft Excel 2010 worksheet will show a series of black dotted-lines that indicate the page breaks for the worksheet. These page breaks typically appear after you have switched views for your worksheet, and have returned to the Normal view. These page breaks can be distracting or confusing, which can lead you to look for ways to remove them.

Fortunately this is a setting that you can change on an individual worksheet basis, so it is possible to hide the page breaks if you no longer wish to display them.

 

Stop Showing Page Breaks in Excel 2010

The steps in this article will show you how to hide page breaks that are showing in the Normal view in Excel 2010. Page breaks are typically shown in this view after you switch to either the Page Layout or Page Break view, then return to the Normal view.

If you save your workbook after making this change, then the page breaks will be hidden in this worksheet until you adjust the same setting again. Page breaks will still be displayed in other worksheets that you open in Excel 2010, as this is not a change to the default Excel 2010 settings, but rather to the individual file.

 

  1. Open your workbook in Excel 2010.
  2.  

  3. Click the File tab at the top-left corner of the screen.
  4. click the file tab

     

     

  5. Click Options at the bottom of the column on the left side of the window.
  6. click the options button

     

     

  7. Click the Advanced tab at the left side of the Excel Options window.
  8. click the advanced tab

     

     

  9. Scroll down to the Display options for this worksheet section, then click the box to the left of Show page breaks to clear the check mark. Click the OK button at the bottom of the window to apply your changes.

uncheck the Show page breaks box

 

 

Be sure to save your workbook after making these changes so that the setting remains applied to the workbook.

 

Would you prefer to use a different default view in Excel 2010? This article will show you how to make that change.

solveyourtech.com newsletter
vintage t rex t-shirt

Disclaimer: Most of the pages on the internet include affiliate links, including some on this site.