Break Line on Worksheet | MyExcelOnline

While working on Excel, sometimes you may see solid or dashed break lines added and the worksheet is divided into multiples pages.

The solid lines are manually inserted ones whereas the dashed line is automatically generated.

break line

These are basically page breaks inserted in Excel for printing purposes! They may be useful when you are trying to print a document but other times are just visually distracting.

You may want to remove these lines before presenting your worksheet to someone!

In this article, we will cover the different ways to remove lines from the worksheet:

So, let’s learn to remove and adjust page breaks in Excel!

Download this Excel workbook so you can practice along with us:

DOWNLOAD EXCEL WORKBOOK

 

Solid Page Break Line

In this screenshot, we have two solid lines inserted in the worksheet.

Break Line on Worksheet | MyExcelOnline

These are manually added page breaks and can easily be removed by following the step-by-step tutorial below:

STEP 1: Select the cell just below the page break line.

Break Line on Worksheet | MyExcelOnline

STEP 2: Go to the Page Layout tab.

Break Line on Worksheet | MyExcelOnline

STEP 3: Click on Breaks in the Page Setup group.

Break Line on Worksheet | MyExcelOnline

STEP 4: Click on Remove Page Break.

Break Line on Worksheet | MyExcelOnline

This will remove the page break between row 9 and row 10!

Break Line on Worksheet | MyExcelOnline

Now, follow the same steps to remove the solid line between rows 15 and 16.

Break Line on Worksheet | MyExcelOnline

 

Dotted Page Break Line

When you select the Page Break Preview in Excel, the dotted and solid lines dividing the worksheet into different pages become visible.

Break Line on Worksheet | MyExcelOnline

Now when you go to View > Normal, the page preview is returned to normal but the lines still visible.

Break Line on Worksheet | MyExcelOnline

To remove the solid lines, follow the steps mentioned below. But, this will not remove the dashed lines.

Break Line on Worksheet | MyExcelOnline

To remove the dashed line, follow the steps below:

STEP 1: Select the File tab.

Break Line on Worksheet | MyExcelOnline

STEP 2: Click Options from the menu on the left side

Break Line on Worksheet | MyExcelOnline

STEP 3: In the dialog box, click on Advanced from the left panel

Break Line on Worksheet | MyExcelOnline

STEP 4: Under display options for this worksheet, uncheck Show Page Breaks.

Break Line on Worksheet | MyExcelOnline

This will remove the dashed lines from the worksheet as well!

Break Line on Worksheet | MyExcelOnline

 

Conclusion

If you wish to remove the solid page break line, select the cell below (or cell right to) the horizontal page break line (or vertical page break line) and select click on Page Layout > Breaks > Remove Page Break.

If you wish to remove the dashed page break line, go to File > Options > Advanced > Uncheck Show Page Breaks.

 

HELPFUL RESOURCE:

Make sure to download our FREE PDF on the 333 Excel keyboard Shortcuts here:

Microsoft Excel Training

You can learn more about how to use Excel by viewing our FREE Excel webinar training on FormulasPivot TablesPower Query, and Macros & VBA!

If you like this Excel tip, please share itEmail this to someone

email

Pin on Pinterest

Share on Facebook

Tweet about this on Twitter

Share on LinkedIn

Break Line on Worksheet | MyExcelOnline