How to Remove Dotted Lines in Excel for Mac: Hide Page Breaks and Print Lines
In Excel for Mac, dotted page break lines that remain on a sheet after Print Preview usually disappear immediately by switching views. If needed, you can also reset manual breaks, clear the print area, or turn off the display option.
Quick Fix — 30 Seconds
- Switch to View → Page Layout.
- Switch back to Normal → the dotted lines disappear.
What Do the Dotted Lines Mean?
- Page breaks: Print boundaries (gray or blue dotted lines)
- Gridlines: On-screen worksheet gridlines (not printed; optional)
- Borders: Solid formatting lines (printed)
5 Standard Fixes for Mac
1) Switch Views
View → Page Layout → Normal.
2) Reset Manual Page Breaks
Page Layout → Breaks → Reset All Page Breaks.
3) Clear the Print Area
Page Layout → Print Area → Clear Print Area.
4) Turn Off the Display Option (Reference)
In Preferences (View/Advanced or a similar menu), turn off page break display.
5) Close and Reopen Without Saving
In some cases, the lines are a preview artifact and disappear immediately after you close and reopen the file.
Windows Path (for Collaboration)
- Switch views: View → Page Break Preview → Normal
- Reset: Page Layout → Breaks → Reset All Page Breaks
- Print area: Page Layout → Clear Print Area
- Display option: File → Options → Advanced → clear “Show page breaks”
Troubleshooting
| Symptom | Cause | Solution |
|---|---|---|
| Dotted lines persist | Preview artifact | Switch views or close and reopen without saving |
| Dark solid lines | Borders | Change the borders to No Border |
| Printed output is cut off | Print area/page break settings | Run Clear Print Area and Reset All Page Breaks |
| Only occurs during collaboration | OS or option differences | Document and standardize the display settings |