EDUCBA

EDUCBA

MENUMENU
  • Explore
    • Lifetime Membership
    • All in One Bundles
    • Fresh Entries
    • Finance
    • Data Science
    • Programming and Dev
    • Excel
    • Marketing
    • HR
    • PDP
    • VFX and Design
    • Project Management
    • Exam Prep
    • All Courses
  • Blog
  • Enterprise
  • Free Courses
  • Log in
  • Sign up
Home Excel Excel Resources Excel Tips Excel Insert Page Break

Excel Insert Page Break

Madhuri Thakur
Article byMadhuri Thakur

Updated August 21, 2023

Excel Insert Page Break

Excel Insert Page Break

In this article, we will learn about Excel Insert Page Break. Page Breaks in Excel limit the page length to avoid misaligning data while printing it. It happens when we print any Excel sheet; due to the different Rows sizes, any row’s data may get split into 2 different pages. By this, we can get the complete data into one sheet and also be selective in choosing which and how many columns a page can accommodate. Page Breaks is available in the View menu tab under Workbook View with the name Page Break Preview. To insert a page break, select a row or column, then click on Insert Page Break from the Right-click menu list.

ADVERTISEMENT
Popular Course in this category
FINANCIAL MODELING & VALUATION Course Bundle - 51 Courses in 1 | 30 Mock Tests | World's #1 Training

Start Your Free Excel Course

Excel functions, formula, charts, formatting creating excel dashboard & others

  • There is an option in the page layout tab; under the page setup section, there is an option for breaks. Have a look at the screenshot below.

Excel Insert Page Break

There are two options in Breaks:

  • Insert Page Break
  • Remove Page Break

Insert page break is to insert a new page break in any data while removing page breaks. Remove the break we gave already.

How to Insert Page Break in Excel?

To use page breaks, we need to perform the following steps:

  • Select the first Row
  • Click on Breaks in the page layout tab under the page setup section
  • Check for print preview

Let us learn how to Insert a page break in Excel with a few examples by following the above steps.

You can download this Insert Page Break Excel Template here – Insert Page Break Excel Template

Example #1

  • Suppose we have the following data in our worksheet.

Excel Insert Page Break Example 1-1

  • We want both sets of tables printed separately. If we currently print the sheet, we can see that it prints the whole table together. Press the CTRL + P and check.

Excel Insert Page Break Example 1.2

  • To insert a page break, Select a row from where we want to begin a new page.

Excel Insert Page Break Example 1-3

  • Under the page layout section, click on Breaks in the page layout tab; three options pop up. Click on Insert Page Break.

Page Break Example 1-4

  • Here’s what our data looks like now.

Excel Insert Page Break Example 1-5

4. Now check for print preview.

Excel Insert Page Break Example

5. This is for the first page.

Excel Insert Page Break Example 1-7

6. Click on the Second page to see the print preview.

Excel Insert Page Break Example 8

7. The second data set is in the print preview.

Print Preview 01

Example #2

  • We have a second set of data to be printed, which is as below. We want the first set printed on the first page and the second set on another.

Excel Insert Page Break Example 2-1

  • First, we select the row where we want to insert a page break.

Excel Insert Page Break Example 2-2

  • Now in the Page Layout Tab, click on Breaks and Insert Page Break under the page setup section.

page break

  • Let us look at the Data First.

Excel Insert Page Break Example 2-4

  • Now we will check for the print preview and click the CTRL + P.

Print Preview 02

5. This is the first page, as we can see below.

Excel Insert Page Break Example 2-6

6. Now click on the second page to view the second data set.

Excel Insert Page Break Example 2-7

7. We can see that our second set of data is printed in the print preview.

Print Preview 0-1

Example #3

  • Now let us try with three sets of data. Have a look at the data below.

Page Example 3-1

  • Select the first row for the page break.

Page Example 3-2

  • In the Page Layout Tab, click on Breaks under the page setup section.

Page Example 3.3

  • Now click on Insert Page Break.

Page Example 3-5

  • The print preview shows that the first set is printed independently while the other two are together.

Page preview 0-3

  • To Confirm, we can see below that it is page 1 of the print preview.

Excel Insert Page Break Example 2-6

  • Now, if we click on 2, we can see the second page of the print preview.

Excel Insert Page Break Example 2-7

  • The second preview looks like this.

Print Preview

  • We also want to break the rest of the two tables on different pages. So we again select the first row for the page break between the second and third tables.

Example 3-7

  • Now in the Page Layout Tab, click on Breaks under the page setup section.

Page Example 3.8

  • Now click on Insert Page Break.

Page Example 3-9

  • Now, if we check for print preview, we can see that there are now three different pages.

Page Break Example 3-0

  • If we directly go to the third page, we can see that the third table is also being printed independently.

Page Break Example 3

  • Below is the screenshot for the print preview of the third data set.

Page preview 0-4

Things to Remember about Excel Insert Page Break

  • Always remember to select the first row before inserting any page break.
  • Also, do not forget to check for a print preview to see if the page breaks are correct.
  • We have already discussed why we use page breaks in Excel. It is because we want the data to be printed separately from one another.
  • There is an option in the page layout tab; under the page setup section, there is an option for breaks.

Recommended Articles

This has been a guide to Excel Insert Page Break. Here we discussed how to use Excel Insert Page Break and practical examples. You can also go through our other suggested articles to learn more –

  1. Excel Insert Date
  2. Excel Insert Row Shortcut
  3. Page Setup in Excel
  4. Insert Comment in Excel
ADVERTISEMENT
MICROSOFT POWER BI Course Bundle - 8 Courses in 1
34+ Hours of HD Videos
8 Courses
Verifiable Certificate of Completion
Lifetime Access
4.5
ADVERTISEMENT
MS Excel & VBA for Data Science Course Bundle - 24 Courses in 1 | 10 Mock Tests
87+ Hours of HD Videos
24 Courses
10 Mock Tests & Quizzes
Verifiable Certificate of Completion
Lifetime Access
4.5
ADVERTISEMENT
All-in-One Financial Analyst Masters Training Program Bundle - 550+ Courses | 300+ Mock Tests | 2000+ Hours | Lifetime |
2000+ Hours of HD Videos
43 Learning Paths
550+ Courses
Verifiable Certificate of Completion
Lifetime Access
4.9
ADVERTISEMENT
All-in-One Data Science Bundle - 400+ Courses | 550+ Mock Tests | 2000+ Hours | Lifetime |
2000+ Hour of HD Videos
80 Learning Paths
400+ Courses
Verifiable Certificate of Completion
Lifetime Access
4.7
Primary Sidebar
Footer
About Us
  • Blog
  • Who is EDUCBA?
  • Sign Up
  • Live Classes
  • Certificate from Top Institutions
  • Contact Us
  • Verifiable Certificate
  • Reviews
  • Terms and Conditions
  • Privacy Policy
  •  
Apps
  • iPhone & iPad
  • Android
Resources
  • Free Courses
  • Excel Charts
  • Excel Tips
  • All Tutorials
Certification Courses
  • All Courses
  • Excel VBA Course - All in One Bundle
  • VBA Course
  • Excel Data Analysis Course
  • Excel for Marketing Course
  • Excel for Finance Course
  • Excel for HR Training

ISO 10004:2018 & ISO 9001:2015 Certified

© 2023 - EDUCBA. ALL RIGHTS RESERVED. THE CERTIFICATION NAMES ARE THE TRADEMARKS OF THEIR RESPECTIVE OWNERS.

EDUCBA

*Please provide your correct email id. Login details for this Free course will be emailed to you

EDUCBA

Download Insert Page Break Excel Template

Let’s Get Started

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA
Free Excel Course

Excel functions, formula, charts, formatting creating excel dashboard & others

By continuing above step, you agree to our Terms of Use and Privacy Policy.
*Please provide your correct email id. Login details for this Free course will be emailed to you

EDUCBA

*Please provide your correct email id. Login details for this Free course will be emailed to you
EDUCBA

*Please provide your correct email id. Login details for this Free course will be emailed to you
EDUCBA Login

Forgot Password?

EDUCBA

Download Insert Page Break Excel Template

EDUCBA

डाउनलोड Insert Page Break Excel Template

This website or its third-party tools use cookies, which are necessary to its functioning and required to achieve the purposes illustrated in the cookie policy. By closing this banner, scrolling this page, clicking a link or continuing to browse otherwise, you agree to our Privacy Policy

Loading . . .
Quiz
Question:

Answer:

Quiz Result
Total QuestionsCorrect AnswersWrong AnswersPercentage

Explore 1000+ varieties of Mock tests View more

🚀 Extended Cyber Monday Price Drop! All in One Universal Bundle (3700+ Courses) @ 🎁 90% OFF - Ends in ENROLL NOW