How to Move Page Breaks in Excel (With Easy Steps)

If you are looking for ways to move Page Breaks in Excel, this article will serve the purpose. Moving Page Breaks gives you a customized outlook of how your worksheet will look after printing. Most likely, you are familiar with different ways to use Page Breaks in Excel. In this article, we are going to learn 3 simple steps to move page breaks in Excel.


Download Practice Workbook


What Is a Page Break in Excel?

In Excel, we use Page Breaks to separate various portions of worksheets for printing. There are 2 kinds of Page Breaks. They are Automatic Page Breaks and Manual Page Breaks. Automatic Page Breaks are denoted by dotted lines. On the other hand, Manual Page Breaks are represented by solid lines.


3 Simple Steps to Move Page Breaks in Excel

In the following dataset, we have the Average Marks of 4 different classes of a school. We will print them on 4 different pages by moving the Page Breaks.

how to move page breaks in excel

Here, we have used Microsoft Excel 365 version for this article, you can use any other version according to your convenience.


Step 01: Enabling Page Break Preview Option

In the beginning, we need to enable the Page Break Preview option. We can do this in 3 different ways. These are discussed below.

1. Using Status Bar

  • Firstly, click on the marked region of the following image from the Status Bar.

how to move page breaks in excel Enabling Page Break Preview Option

Subsequently, the Page Break Preview option will be enabled like the following image.

how to move page breaks in excel Enabling Page Break Preview Option


2. Utilizing Ribbon Menu

  • Firstly, go to the View tab from the Ribbon.
  • After that, select Page Break Preview from the Workbook Views

Then, the Page Break Preview option will be active.

how to move page breaks in excel Enabling Page Break Preview Option

Read More: How to Insert Page Break in Excel Between Rows


3. Applying Keyboard Shortcut 

  • Press the keyboard shortcut ALT + W + I. This will directly enable the Page Break Preview option as shown in the following picture.

how to move page breaks in excel Enabling Page Break Preview Option

Read More: How to Insert a Page Break in Excel (4 Easy Ways)


Step 02: Modifying Horizontal and Vertical Page Break Positions

  • Firstly, select the Horizontal page break line and drag it to your preferred position.

After dragging the Horizontal Page Break Line, you will see the following image on your screen.

how to move page breaks in excel Modifying Horizontal and Vertical Page Break Positions

  • Similarly, drag the Vertical Page Break Line and reposition it according to your preference.

Consequently, you will get 2 intersecting page break lines showing 4 pages, like the following image.

Read More: How to Insert Page Break Between Rows 39 and 40 in Excel


Step 03: Checking in Print Preview Mode

  • Firstly, press the keyboard shortcut CTRL + P to open the Print Preview of the worksheet.

As a result, you will be able to see that there are 4 different pages in the Print Preview mode as marked in the image given below.

Read More: How to Insert Multiple Page Breaks in Excel (2 Ways)


đź’ˇ Things to Remember

  • If you want to switch back to the Normal View from Page Break Preview at any time, just use the keyboard shortcut ALT + W + L.

Conclusion

Finally, we have come to the end of this article. I truly hope that this article was able to guide you to learn the steps to move page breaks in Excel. Please feel free to leave a comment if you have any queries or recommendations for improving the article’s quality. To learn more about Excel, you can visit our website, ExcelDemy. Happy learning!


Related Articles

Zahid
We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo