Can the page breaks in Excell be highlighted?

Question

I find the page breaks hard to see. Can they be highlighted or coloured?

Answer 1

Page breaks in Excel cannot be highlighted or colored differently. Excel shows:

• Automatic page breaks as dashed lines
• Manual page breaks as solid lines

To make them easier to work with, use Page Break Preview, which enlarges and clearly shows page boundaries:

1. Go to the View tab.
2. Select Page Break Preview.

When finished, return to Normal view:

1. On the View tab, in Workbook Views, click Normal.
2. If the dashed page break lines are distracting in Normal view, they can be hidden:
   • Click File > Options.
   • Go to Advanced.
   • Under Display options for this worksheet, clear Show page breaks.

This does not change their color, but it either makes them more visible (Page Break Preview) or hides them entirely in Normal view.

---

References:

• View page breaks
• Insert, move, or delete page breaks in a worksheet