What Is Page Break View in Excel?

Need to learn what is page break view in Excel? If you are looking for such unique information, you’ve come to the right place. Here, we will take you through the introduction of the page break view along with 5 easy and convenient methods to activate the page break view in Excel.


Download Practice Workbook

You may download the following Excel workbook for better understanding and practice yourself.


What Is Page Break View in Excel?

In Excel, actually, it’s called Page Break Preview instead of page break view. You can see where the page breaks will appear while printing the spreadsheet by using the Page Break Preview option. We use page breaks to separate a worksheet into different pages for printing. Always a visual representation is the best option for better understanding. So, let’s see below.
Suppose we have Sales Report 2021 of a certain company. This dataset contains the Employee Profiles and the Quarterly Sales amount of employees.

What Is Page Break View in Excel

Now, if we use the Page Break Preview option, the sheet will look like the following one.

What Is Page Break View in Excel

In the picture above, we can see two lines. One is a vertical dashed line, another is a horizontal solid line. These indicate two types of page breaks.

  1. Automatic Page Break: Excel adds page breaks spontaneously based on the choices for Paper size, Margins, and Scaling. This type of page break is called automatic page break. In the sheet, it reflects itself with a dashed blue line.
  2. Manual Page Break: If the default page break doesn’t match your printing criteria, you may manually insert a page break with a few easy steps. It’s incredibly handy for printing a range of data with the precise amount of pages you need. This type of page break looks like a solid blue line in the Page Break Preview option.

5 Ways to Activate Page Break View in Excel

Usually, we see the worksheet in the Normal View by default, which is just like the first image of this article. But, we can see the page break lines in our worksheet with the help of Page Break Preview. Now, we’ll show you five different approaches to activating the Page Break Preview option in Excel. So, without further delay, let’s jump into the methods one by one.


1. Navigating to View Tab

In our first method, we’ll get help from the View tab. Follow the steps below.

📌 Steps

  • At first, navigate to the View tab.
  • Then, select the Page Break Preview from the Workbook Views group on the ribbon.

What Is Page Break View in Excel Navigating to View Tab

At this moment, we’re watching the sheet in page break view mode. We clearly can see the sheet divided into two portions by a dashed blue line. It stands for the two portions to be printed on two different pages. Obviously, you can see Page 1 and Page 2 appear as watermarks on the respective pages. These are the corresponding page numbers.

What Is Page Break View in Excel Navigating to View Tab
Note: The Sales amounts aren’t showing in cells in the H6:K24 range. Because the application of Page Break Preview automatically sets the Zoom level to 70%. So, the digits cannot capacitate themselves into the cells. As a result, they are shown with hash (#) signs.

  • Now, set the Zoom level at 90% and you can see those numbers also.

What Is Page Break View in Excel Navigating to View Tab


2. Using Status Bar to Activate Page Break View in Excel

The second method reflects the usage of the Status Bar. Follow the steps carefully.

📌 Steps

  • Firstly, go to the Status Bar at the bottom of the window.
  • Secondly, select the Page Break Preview button at the left of the Zoom Level option.

What Is Page Break View in Excel Using Status Bar

Instantly, you can see the worksheet Status Bar shown in page break view mode.

What Is Page Break View in Excel Using Status Bar


3. Applying Keyboard Shortcut

In this instance, I’m aware of your thoughts. Do shortcut keys exist? You’re lucky! Yes, shortcut keys exist to do this job more quickly. Follow the steps carefully.

📌 Steps

  • Firstly, press the ALT key followed by W and I on your keyboard.

What Is Page Break View in Excel Applying Keyboard Shortcut

  • Then, magically you can see the worksheet in the Page Break Preview mode.

What Is Page Break View in Excel Applying Keyboard Shortcut


Similar Readings


4. Utilizing Print Preview Option

In some situations, you can see the page break utilizing the Print Preview option. The distinction between viewing page breaks in Print Preview and Page Break Preview isn’t too much. You will be able to comprehend the allocation page by page while seeing page breaks in the Print Preview option. But viewing in Page Break Preview allows you to see the whole distribution In this mode, you can see all of the pages and page breaks in the display. Now, follow the steps below.

📌 Steps

  • At the very beginning, press CTRL+P on your keyboard.

What Is Page Break View in Excel Utilizing Print Preview Option

Hence, you can see where the page break will happen while printing.

What Is Page Break View in Excel Utilizing Print Preview Option

What Is Page Break View in Excel Utilizing Print Preview Option


5. Employing VBA Code

Employing the VBA code is always an amazing alternative. Follow the steps below to be able to solve the problem in this way.

📌 Steps

  • Firstly, press the ALT+F11 key.

What Is Page Break View in Excel Employing VBA Code

  • Suddenly, the Microsoft Visual Basic for Applications window will open.
  • Then, go to the Insert tab.
  • After that, select Module from the options.

What Is Page Break View in Excel Employing VBA Code

  • It opens the code module where you need to paste the code below.
Sheet5.Activate
ActiveWindow.View = xlPageBreakPreview

What Is Page Break View in Excel Employing VBA Code

  • Then click on the Run button or press the F5 key on your keyboard.

What Is Page Break View in Excel Employing VBA Code

  • Eventually, the Macros dialog box will open.
  • At this moment, write down a name in the Macro Name box. In this case, we named the macro PBP (Page Break Preview).
  • Then, click on the Create button.

What Is Page Break View in Excel Employing VBA Code

In this instance, you can see the below code in the code module.

Sub PBP()
Sheet5.Activate
ActiveWindow.View = xlPageBreakPreview
End Sub

What Is Page Break View in Excel Employing VBA Code

  • Again, select the Run button.

Employing VBA Code

Instantly, the worksheet VBA looks like the one below.

Employing VBA Code


How to Hide or Show Page Break Marks in Excel

If we change the view to Page Break Preview once, we can see these kinds of lines in the Normal view also.

Hide or Show Marks

Sometimes, it becomes very annoying to see these lines while working on the sheet.
To solve this problem, we can hide the page break lines. Again, we can activate the option to show them as per our preference. Follow the steps below.

📌 Steps

  • Firstly, move to the File tab.

Hide or Show Marks Using Advanced Options

  • Secondly, select Options as shown in the image below.

Hide or Show Marks Using Advanced Options

  • Hence, the Excel Options window opens.
  • Then, go to the Advanced tab.
  • After that, uncheck the box of Show page breaks under the section of Display options for this worksheet.
  • Finally, click OK.

Hide or Show Marks Using Advanced Options

Now, we can’t see any page break lines in our worksheet.

Hide or Show Marks Using Advanced Options

Again, we can show the page break lines repeating the same steps.

Read More: How to Create Different Views for Different Users in Excel


Practice Section

For doing practice by yourself we have provided a Practice section like below in the last sheet named Practice Section on the workbook. Please do it by yourself.

Practice Section


Conclusion

This article provides a brief description of Page Break Preview and how to activate it in Excel. Don’t forget to download the Practice file. Thank you for reading this article, we hope this was helpful. Please let us know in the comment section if you have any queries or suggestions. Please visit our website Exceldemy to explore more.


Related Articles

Shahriar

Shahriar

Hello! Welcome to my Profile. Currently, I am working and doing research on Microsoft Excel and here I will be posting articles related to this. My last educational degree was BSc in Engineering from the Bangladesh University of Engineering & Technology. I am a Naval Architecture and Marine Engineering graduate with a great interest in research and development. I love reading books & traveling. Always try to gather knowledge from various sources and implement them effectively in my work.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo