Skip to content
Related Articles

Related Articles

How to Insert, Move, or Delete Page Breaks in Excel Worksheet?

View Discussion
Improve Article
Save Article
  • Last Updated : 23 Jul, 2022
View Discussion
Improve Article
Save Article

Excel has the functionality to print its data directly from the excel sheet itself. But here comes the problem, if you have data of 300 rows, then you cannot print the entire data on a single sheet of paper, data needs to be divided among different sheets equivalently. Excel can do this automatically. Excel distributes table data into different sheets. But what if we need to distribute our data in a custom user-defined format. Here comes the role of Page Breaks in excel. Excel provides functionality to design your page breaks, and when or where to start or end your printing. Let’s learn how to Insert, Move or Delete Page Breaks in Excel. 

Representation of Automatic and Manual Page Breaks

By default, Excel provides some automatic page breaks. The default page breaks are represented by the dotted lines. The Manual page breaks are shown by the solid lines.

Default-and-manual-page-breaks-shown

 

Normal View, Page Layout View, and Page Break View

Normal View

It’s the full-screen view and the most used view. You always edit your data in this view. We can use Page Breaks, in the Normal view also, but it’s never recommended. Using Page breaks, in the normal view won’t give you the desired level of results, as visualizing the page breaks in this view is very difficult. 

Page-breaks-in-normal-view

 

Page Layout View

The Page Layout View separates your pages in the way you want to print them. This tool is not used much and is not recommended use to apply page breaks. It divides the pages into a printable format. 

Division-of-pages-in-page-layout-view

 

Page Break View

The page break view is itself made to apply your custom page breaks and to visualize them effectively. It’s one of the most used views to apply page breaks in your sheet before printing it. 

Custom-page-break-through-page-break-view

 

Easy Access to all Views

There could be several ways to open all kinds of views. But, here, we will discuss two of the easiest methods to open any kind of View. 

Method 1: By using View Tab

Go to View Tab; under the Workbook Views section, you will all types of views available in excel i.e. Normal View, Page Layout View, and Page Break View. 

Open-workbook-views

 

Method 2: In the Status Bar

In the right-most corner of the Status bar, there are three buttons, scheduled in the order Normal View, Page Layout View, and Page Break View. This is one of the easiest methods to access the different types of Views. 

Accessing-different-types-of-view

 

Insert, Move or Delete Page Break

Given Employee and Project table with their visualization chart. With the help of Page breaks, we have to divide the sheet into four equal halves. By default, a page break is there in between Employee and Project table. 

Automated-generated-page-break

 

Insert  a Page Break 

Step 1: Go to Page Break View, present in the right-most corner of your status bar. 

Inserting-page-break-view

 

Step 2: As you want to divide your worksheet into four parts. So, keep your active cell at G11. The page breaks are always created from the top left corner of your cell. 

Dividing-worksheet-in-four-parts

 

Step 3: Go to the Page Layout tab. Under the Page Setup section, click on Breaks. A drop-down appears. Select Insert Page Break. 

Inserting-page-break-from-breaks

 

Step 4: Two-page breaks appear i.e. horizontal and vertical page breaks. This divides your sheet into four halves. You can observe that the default dotted line has disappeared automatically. 

Horizontal-and-vertical-page-break

 

Step 5: Let’s roll back to the original data set. What if you want only a vertical page break to be inserted in your sheet. Select the entire column G in your worksheet. 

Selecting-column-G

 

Step 6: Go to the Page Layout tab. Under the Page Setup section, click on Breaks. A drop-down appears. Select Insert Page Break

Selecting-insert-page-break

 

Step 7: Your page gets, divided vertically into 2 sections i.e. Page 1 and Page 2. 

Vertical-two-divisions-of-page

 

Step 8: Let’s again roll back to our original data set. What if you want only a horizontal page break to be inserted in your sheet? Select the entire row 11 in your worksheet. 

Selecting-row-11

 

Step 9: Go to the Page Layout tab. Under the Page Setup section, click on Breaks. A drop-down appears. Select Insert Page Break. 

Selecting-insert-page-break

 

Step 10: Your page gets, divided horizontally into 2 sections i.e. Page 1 and Pag 2. 

Horizontally-page-divided

 

Remove Page Break 

Step 1: Considering you have created a page break as shown above. Now, you need to remove the page break as per your wish. Go back to the cell, G11. 

Selecting-cell-G11

 

Step 2: Go to the Page Layout tab. Under the Page Setup section, click on Breaks. A drop-down appears. Select Remove Page Break.

Selecting-remove-page-breaks

 

Step 3: The Page Break gets removed. 

Page-break-removed

 

Move Page Breaks

Step 1: Consider the Page break inserted in the sheet. Now, if you want to move your vertical page break one position right, then you can use Move Page break. Put your cursor on the vertical page break line, until a double-sided arrow does not appear. 

Mouse-cursor-showing-double-sided-arrow

 

Step 2: Now, left-click your mouse, hold and drag it to any position you want to have your vertical page break. For example, dragging my mouse to one position right. 

Dragging-mouse-to-right-position

 

Step 3: Leave your left click, and your vertical page break has moved towards one step right. 

Page-break-shifted-one-step-right

 


My Personal Notes arrow_drop_up
Recommended Articles
Page :

Start Your Coding Journey Now!