What Is Page Layout View in Excel? (Detailed Analysis)

This tutorial will demonstrate what is page layout view in excel?. The excel file is best for calculation or recording large data in a properly categorized way. But when officially you have to submit a report then you have to print the excel file. Page layout is used to set the desired layout as you want to print it on the report.


Download Practice Workbook

You can download the practice workbook from here.


What Is Page Layout View?

Page layout is used to describe a certain group of commands which are used to set the appearance on a printed copy of the worksheet. The goal is to use it to make the printed copy easier to understand for the reader. Moreover,  this option can guide to the best option for better visual representation and control of it.


Steps to Switch In and Out from Page Layout View

We aim to switch in and out from the page layout view to make the desired printed copy accordingly. To learn how to switch in and out from the page layout view we have to follow the below steps.

Steps:

  • At first, we arranged a dataset. We have Column B as Name and in Column C we have Working Hours.

Switch in and out from Page Layout View

  • Then, go to the View tab and select the Page Layout option.

Switch in and out from Page Layout View

  • After that, we will get the result like the image below.

Switch in and out from Page Layout View

  • Now, if we want to switch out from the Page Layout View then we have to go to the View tab again and select the Normal option this time.

Switch in and out from Page Layout View

  • Then you will get the below result.

Switch in and out from Page Layout View


Modify Page Layout View in Excel

In the case of using a page layout view, it is very important to modify the different settings of the page view so that it can be presented in a proper way. The different approaches to modifying page layout view are described below:


1. Setting and Modifying Custom Margins

In this case, our goal is to set and modify the custom margins to modify the page layout view. The steps are given below to learn this process.

Steps:

  • First, go to the Page Layout tab.
  • Next, click on the Margins option and select the Custom Margins option.

Modify Page Layout View in Excel

  • Then, the Page Setup window will come onto the screen.
  • Afterward, make the changes in the Margins option accordingly and press OK.

Modify Page Layout View in Excel

  • Lastly, you will get the below result.

Modify Page Layout View in Excel

Read More: How to Show Only One Page in Excel Page Layout View (4 Ways)


Similar Readings


2. Fixing Page Orientation and Size

In this case, our goal is to fix the page orientation and size to print it according to your wish. The steps of this process are given below.

Steps:

  • Initially, go to the Page Layout tab.
  • Next, click on the Margins option and select the Custom Margins option.
  • After that, the Page Setup window will open on the screen.
  • From this window, select both the Horizontally and Vertically option in the Center on page option of the window and press OK.

Modify Page Layout View in Excel

  • Then, you will get the below result.

  • Moreover, when printing you can select the page orientation you want.
  • For this, go to the Page Layout tab and click on the Orientation
  • Then select either Portrait or Landscape option accordingly.

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


3. Inserting or Removing Page Breaks

In this case, we aim to insert or remove page breaks to print the data accordingly for better visualization.

Steps:

  • At first, select the row you want to insert a page break.
  • Then go to the Page Layout tab and click on the Breaks option.
  • Next, choose the Insert Page Break option.

  • Then, you will get the below result.

  • After the work is done, you can remove the page break also.
  • For that again go to the Page Layout tab and from the Breaks option select the Remove Page Break option.

  • Finally, you will get the below result.

Read More: What Is Page Break View in Excel?


Things to Remember

  • We have shown the steps overall. But you don’t have to use all the portions at the same time. You have visualized what you want to represent and only then use the processes according to your need. Remember that using all options doesn’t make the presentation easy to understand all the time. So, use the options carefully so that they can be useful to you and the viewer as well.

Conclusion

Henceforth, follow the above-described methods. Thus, you can learn what is page layout view in excel. Let us know if you have more ways to do the task. Follow the ExcelDemy website for more articles like this. Don’t forget to drop comments, suggestions, or queries if you have any in the comment section below.


Related Articles

Zehad Rian Jim
We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo