How to Insert a Page Break in an Excel Worksheet

Beginner 45 min 11 steps 17389 views Rating: 3.8/5 Published: 2026-03-23

Open your spreadsheet.. Open the Page Setup options.. Enable adjusted scaling.

Start Playback
S
Author

Steps

1

Open your spreadsheet.

Step 1

Open your spreadsheet.

2

Open the Page Setup options.

Step 2

Open the Page Setup options.

3

Enable adjusted scaling.

Step 3

Enable adjusted scaling.

4

Enter Page Break view.

Step 4

Enter Page Break view.

5

Click the row below your desired horizontal page break location.

Step 5

Click the row below your desired horizontal page break location.

6

Insert the horizontal page break.

Step 6

Insert the horizontal page break.

7

Select the column to the right of your desired vertical line break.

Step 7

Select the column to the right of your desired vertical line break.

8

Insert the vertical page break.

Step 8

Insert the vertical page break.

9

Move your page break.

Step 9

Move your page break.

10

Delete a page break.

Step 10

Delete a page break.

11

Return to Normal view.

Step 11

Return to Normal view.

View as Slideshow

Rate This Guide

★ ★ ★ ☆ ☆ 3.8/5
3

Comments (0)

No comments yet. Be the first to share your thoughts!