How to Hide Dotted Page Break Lines in Excel Before Printing
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.
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.
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.
In Excel, select View > Normal to leave Page Break Preview.
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.
Select File > Print and review the preview. Page break guides do not appear on printed pages.
Adjust page breaks to change the print layout
Use this method when you want to change where Excel divides the worksheet into printed pages.
Remove printable borders or gridlines
Use this method if the lines appear in Print Preview and are not just page break guides.
Review Excel Page Breaks in WPS Spreadsheets
Open your Excel worksheet in WPS Spreadsheets, switch views, and check the print preview before printing.
- 1. Open the worksheet: Open WPS Spreadsheets and use File > Open to select your Excel workbook.
- 2. Review page breaks: Select View > Page Break Preview to inspect how the worksheet is divided into printed pages.
- 3. Return to Normal view: Select View > Normal to leave Page Break Preview.
- 4. Preview and print: Select File > Print, review the page layout, and adjust the print settings if needed before printing.

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.




