Pinterest Pixel

Break Line on Worksheet

While working on Excel, sometimes you may see solid or dashed break lines added and the worksheet... read more

Download Excel Workbook
John Michaloudis
Posted on

Overview

Break Line on Worksheet | MyExcelOnline 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 on Worksheet

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 workbookBreak-Lines-on-Worksheet.xlsx

 

Solid Page Break Line

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

Break Line on Worksheet

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

See also  The Ultimate Guide to Euclidean Distance Calculator in Excel

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

Break Line on Worksheet

STEP 2: Go to the Page Layout tab.

Break Line on Worksheet

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

Break Line on Worksheet

STEP 4: Click on Remove Page Break.

Break Line on Worksheet

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

Break Line on Worksheet

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

Break Line on Worksheet

 

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

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

Break Line on Worksheet

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

Break Line on Worksheet

To remove the dashed line, follow the steps below:

STEP 1: Select the File tab.

Top 20 Common Excel Problems Solved

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

See also  $ Dollar Sign in Excel: Absolute, Relative, and Mixed Cell References

Top 20 Common Excel Problems Solved

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

Top 20 Common Excel Problems Solved

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

Break Line on Worksheet

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

Break Line on Worksheet

 

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.

 

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

If you like this Excel tip, please share it
Break Line on Worksheet | MyExcelOnline Break Line on Worksheet | MyExcelOnline

Get Video Training

Advance your Microsoft Excel & Office Skills with the MyExcelOnline Academy!

Dramatically Reduce Repetition, Stress, and Overtime!
Exponentially Increase Your Chances of a Promotion, Pay Raise or New Job!

Learn in as little as 5 minutes a day or on your schedule.

Learn More!

Share to...