Printing Problems

How to Hide Dotted Page Break Lines in Excel Before Printing

Emma BrownEmma Brown Nov 14, 2026 868 views

Question details

The user wants to hide or remove dotted or dashed lines in Excel before printing.

Product
Microsoft Excel
Device & OS
not provided
Scenario
Preparing an Excel worksheet for printing and reviewing its page layout.
Observed behavior
Dashed blue lines appear as page break guides in Page Break Preview; the guides themselves do not print.
Before you start

Open the worksheet and check whether the lines appear in View > Page Break Preview. Then open File > Print to see whether they appear in the print preview.

Solution 1Recommended

Switch to Normal view and hide page break guides

Use this method when the lines are page break guides and you want to hide them while working.

1
Switch views

In Excel, select View > Normal to leave Page Break Preview.

2
Hide remaining guides

If dotted page break lines remain visible, in Excel for Windows go to File > Options > Advanced. Under Display options for this worksheet, clear Show page breaks and select OK.

3
Check the printout

Select File > Print and review the preview. Page break guides do not appear on printed pages.

Lines in the print preview: If lines also appear in Print Preview, they may be cell borders or printed gridlines rather than page break guides.
Print worksheets with WPS Office

Review Excel Page Breaks in WPS Spreadsheets

Open your Excel worksheet in WPS Spreadsheets, switch views, and check the print preview before printing.

  1. 1. Open the worksheet: Open WPS Spreadsheets and use File > Open to select your Excel workbook.
  2. 2. Review page breaks: Select View > Page Break Preview to inspect how the worksheet is divided into printed pages.
  3. 3. Return to Normal view: Select View > Normal to leave Page Break Preview.
  4. 4. Preview and print: Select File > Print, review the page layout, and adjust the print settings if needed before printing.
Review page breaks and the worksheet print layoutOpen and edit Microsoft Excel XLS and XLSX filesUse familiar spreadsheet menus and print controlsGet started with WPS Office for free
microsoft office alternative - wps office

Frequently Asked Questions

Do Excel's dashed page break lines print?

No. Page break guides show where pages will divide, but they do not print. Check File > Print to preview the printed pages.

Why are dotted lines still visible in Normal view?

Excel may still display page break guides in Normal view. In Excel for Windows, go to File > Options > Advanced and clear Show page breaks under Display options for this worksheet.

How do I change where an Excel worksheet splits across pages?

Select View > Page Break Preview and drag a blue page break line. You can also use Page Layout > Breaks to insert or remove a manual break.

What should I check if the lines appear in Print Preview?

They may be cell borders or printed gridlines. Check Home > Borders for the selected cells and Page Layout > Gridlines > Print for worksheet gridlines.