Now we can move the page break up or down, depends on where we need to place it. What we can do though is move the automatically inserted page breaks around and place them exactly where we need.įor example, we’ll click on this horizontal page break and the cursor changes into a double-headed arrow. We can’t do that for one reason – every large document has to have some page breaks.
#How to get rid of section break excel how to#
How to Remove the Dotted Line (Automatically Inserted Page Break) The manually inserted vertical page break has disappeared.īut let’s carry on and have a look at what happens if we want to remove the dotted line, which is an automatically inserted page break. In the tab ‘ Page Layout’, click on ‘Breaks’ and then ‘Remove Page Break’ and that’s all it takes! We can remove any manually inserted vertical page break practically the same way, but we need to click on a cell located to the right of the page break line. How to Remove the Manually Inserted Vertical Page Breaks Then go to the tab ‘Page Layout’, click on ‘Breaks’ and select ‘Remove Page Break’. To remove a manually inserted horizontal page break, we need to click on the cell below it.
Let’s have a look first at how to remove the manually inserted page breaks and then we’ll go through how to work with the automatically inserted page breaks. How to Remove the Manually Inserted Horizontal Page Breaks The blue solid lines are manually inserted page breaks. These are displayed based on the general settings such as the paper size, margins, page orientation, and others. The blue dotted lines are automatically inserted page breaks. Now, here’s an important thing to remember. This way we’ll be able to see all the page breaks present in the current document.
Go to the tab ‘View’ and click on ‘Page Break Preview’. To work with page breaks in Excel, first we need to switch the view mode to see them. 5 How to Remove All Manually Inserted Page Breaks at Once How to Work with Page Breaks in Excel