How to hide dotted page-break lines in Excel
To hide page-break lines in Excel’s Normal view, open File → Options → Advanced. Under Display options for this worksheet, clear Show page breaks. The setting changes what you see on the selected sheet and leaves the print boundaries and page count in place. These steps apply to desktop Excel for Windows.
Identify a print page boundary
If dotted lines appeared between a few rows or columns after you opened Print Preview, they probably mark page boundaries. Excel divides the sheet based on paper size, margins, scaling and any breaks you inserted manually.
Faint lines around each cell are gridlines. A line you formatted around a range may be a cell border. Those lines remain when you hide page breaks.
How to hide worksheet gridlines in Excel
Hide the page breaks in Normal view
- Select the worksheet with the dotted lines and open File at the upper left.
- Choose Options from the File menu, then select Advanced in Excel Options.
- Under Display options for this worksheet, verify the selected sheet, clear Show page breaks, and select OK.
If the lines are still visible, use View → Normal. Page Break Preview is designed to show the print boundaries. Repeat the setting on any other sheet affected. Turn on the same box when you want to see the lines again.
Compare the screen with Print Preview
If a table was split across two pages, hiding the lines leaves the same page count when you press Ctrl+P. If the right-hand columns are spilling onto another page, consider landscape orientation or a different scaling setting under Page Layout.
Change the printed breaks or remove manual breaks
To remove a manual break, go to View → Page Break Preview. Select the column to the right of a vertical break or the row below a horizontal break. Then select Page Layout → Breaks → Remove Page Break. Use Reset All Page Breaks to remove all manual breaks.
Excel calculates automatic boundaries. To change them, adjust the page orientation, margins or scale and check the page count and text size in Print Preview.




