Page Break Preview (Interface)
Shows blue lines where pages will split, and lets you drag those lines to change where they fall.
Move the Page Breaks Yourself
When a report splits three columns onto a second page, Page Break Preview lets you drag the split rather than fight with scaling settings.
- Blue lines appear — Where the pages split
- Drag a line — The break moves
- Excel rescales — To fit what you asked for
How to do it
View tab ▸ Workbook Views ▸ Page Break Preview or the right hand view button
Solid blue lines are breaks you set. Dashed blue lines are breaks Excel worked out itself.
| Item | What it does |
|---|---|
| Blue solid line | A break you set manually |
| Blue dashed line | An automatic break |
| Drag a line | Moves the break |
| Grey area | Outside the print area |
Reading the Blue Lines
View ▸ Page Break Preview ▸ drag the blue line to the right
| What you see | What it means |
|---|---|
| Solid blue line | A manual page break |
| Dashed blue line | An automatic page break |
| Page 1 watermark | Which page you are looking at |
| Grey shaded area | Not in the print area |
| Dragging outwards | Excel shrinks the print to fit |
Result: Drag it
Drag a break too far and Excel shrinks the print until it is unreadable. Watch the scale.
Do this
- Drag breaks to control where pages split
- Watch the scaling percentage as you drag
- Return to Normal when finished
Avoid
- Dragging so far the print becomes tiny
- Confusing manual and automatic breaks
- Leaving the file in this view for others
📌 Dragging a break outwards makes Excel shrink the print to fit, so watch the scaling percentage.
Practice
- Switch to Page Break Preview.
- Drag a blue line and watch the scaling.
- Return to Normal view.
Quick quiz: You drag a page break far to the right to fit more columns. What does Excel do?
- Prints the extra columns at full size anyway
- Shrinks the whole print to fit, which can make it unreadable
- Refuses to move the break
Show answer
Page Layout ▸ Scale to Fit ▸ check the scaling percentage — Moving a break outwards forces Excel to scale everything down.
🔒 Want the full interactive course? This is a free preview. The complete 39-module Excel Master Course — with hands-on lessons, quizzes and a certificate — is available inside the app.
Learn Excel the fun way
Bite-size interactive lessons, quizzes, streaks and a certificate.
Start free →
Bite-size interactive lessons, quizzes, streaks and a certificate.
Start free →