See all How-To Articles

How to Hide Page Breaks in Excel

This tutorial demonstrates how to hide page breaks in Excel.

 

hide page breaks 6

 

Hide Page Breaks

In Excel, you can choose where to go to the next page when printing by setting page breaks. To hide them while you are in normal view, follow these steps:

 

hide page breaks 6

 

1. In the Ribbon, go to File > Options.

 

hide page breaks 2

 

2. In the Excel Options window choose Advanced from the menu on the left and scroll down to the Display options for this worksheet section. Uncheck the Show page breaks box, and press OK.

 

hide page breaks 3

 

Now page breaks are hidden.

 

hide page breaks 4