The Dotted Line Distraction
If you frequently print spreadsheets or generate PDFs from Microsoft Excel, you have likely encountered the automatic page break feature. The moment you open the Print Preview screen (File > Print) and then return to your normal worksheet, Excel permanently overlays a series of dashed or dotted lines across your entire grid. These lines represent exactly where the physical page cuts will occur if you hit print. While useful during the final formatting stage, having these harsh dashed lines permanently slicing through your data while you are actively trying to write formulas or analyze numbers is incredibly distracting.
How to Hide the Automatic Page Breaks
You cannot stop Excel from mathematically calculating where the page breaks belong, but you can force the software to hide the visual dashed lines so you can work in peace.
1. Open Microsoft Excel.
2. Click on the File tab in the top-left corner of the ribbon.
3. Click Options at the bottom of the left-hand sidebar.
4. In the Excel Options window, click on Advanced in the left menu.
5. Scroll roughly halfway down the massive list of settings until you find the section titled Display options for this worksheet.
6. Ensure the correct worksheet is selected in the dropdown menu next to the title.
7. Look for the checkbox labelled Show page breaks.
8. Untick the checkbox.
9. Click OK.
The dashed lines will instantly vanish from your active worksheet.
The Crucial Limitation
It is very important to understand that this setting is not global. The “Show page breaks” toggle is saved on a per-worksheet basis. If you create a new tab in your workbook, or if you open a completely different Excel file, the dashed lines will likely return the next time you trigger the Print Preview screen, requiring you to navigate back into the Advanced Options menu to turn them off for that specific sheet.