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

Get FREE Advanced Excel Exercises with Solutions!

Sometimes we have to deal with large datasets. In most cases, one or two columns go to the 2nd page which makes the dataset bad to work on. In that case, we have to fit that large dataset into one page to maintain continuity. There are several procedures where you can show the page layout view on one page in Microsoft Excel. In this article, we will focus on how to show the page layout view on one page only in Excel. I hope you find this article informative.


How to Show Only One Page in Excel Page Layout View: 4 Easy Methods

To show the page layout view on one page in Excel, we have found four different methods through which you can have a clear idea. All of these methods are fairly easy to understand. To show all these methods perfectly, we take a large dataset that includes the order date, customer name, product id, order location, book name, authors, book type, and purchase price.

Excel Page Layout View One Page Only

If you look at the page layout view, you will find the page is divided into two. On the first page, you will get six columns.

On the next page, you will get the other three columns.

We need to show all the columns on one page only in the page layout view. To do this follow the methods carefully.


1. Modifying Page Setup

Our first method is basically using the page setup option. Utilizing the page setup option, we want to show the page layout view on one page only. To understand this method, follow the steps carefully,

Steps

  • First, go to the Page Layout tab in the ribbon.
  • Then, click on Dialog Box Launcher in the bottom right corner.

  • It will open up the Page Setup dialog box.
  • Then, select the Page tab in the Page Setup dialog box.
  • After that, from the Scaling section, select the Fit to option instead of Adjust to.
  • Finally, click on OK to apply the change.

Excel Page Layout View One Page Only

  • Then, go to the View tab in the ribbon.
  • From the Workbook Views group, select Page Layout.

  • As a result, you will see the dataset on one page only. See the screenshot.

Excel Page Layout View One Page Only


2. Altering Page Orientation

We can alter the page orientation to show the page layout view on one page only. By default, Microsoft Excel will show your dataset in portrait mode but by changing the orientation from portrait to landscape, you can get your desired solution. To understand this method properly, follow the steps.

Steps

  • First, go to the Page Layout tab in the ribbon.
  • Then, click on Dialog Box Launcher in the bottom right corner.

  • It will open up the Page Setup dialog box.
  • Then, select the Page tab in the Page Setup dialog box.
  • From the Orientation section, change the orientation from Portrait to Landscape.
  • Then, from the Scaling section, change from Adjust to 100% normal size to Adjust to 80% normal size.
  • Finally, click on OK at the bottom right corner.

Excel Page Layout View One Page Only

  • Then, go to the View tab in the ribbon.
  • From the Workbook Views group, select Page Layout.

  • As a result, you will see the dataset on one page only. See the screenshot.

Excel Page Layout View One Page Only


Similar Readings


3. Changing Page Width

We can change the page width and set it to one page. This will set all the columns on one page and show the page layout view on one page only. To understand the method clearly, you need to follow the steps carefully.

Steps

  • First, go to the Page Layout tab in the ribbon.
  • Then, from the Scale to Fit group, select the Width drop-down option.

  • After that, change the Width from Automatic to 1 page.

Excel Page Layout View One Page Only

  • Then, go to the View tab in the ribbon.
  • From the Workbook Views group, select Page Layout.

  • As a result, you will see the dataset on one page only. See the screenshot.

Excel Page Layout View One Page Only


4. Wrapping Text and Resizing Column Width

We can wrap text and resize column width to show the page layout view on one page only. When you have some large name in a column, then adjusting the column and wrapping text can be a perfect solution to fit them on one page. To understand the method clearly, you need to follow the steps.

Steps

  • If you look at the dataset, you will see several columns are so large. With the Wrap Text option, you can adjust several lines and make the dataset fit on one page.
  • To do this, select range of columns C to J.

  • Then, go to the Home tab in the ribbon.
  • From the Alignment group, select the Wrap Text option.

  • Then, move the mouse cursor to the boundary line between two columns, and it will convert into resize icon.
  • After that, do the resize according to your condition to fit on one page.

  • While resizing the columns, the rows become congested
  • In that case, you can resize row height accordingly.
  • The resize icon will appear when you take the mouse cursor between two rows.

  • Then, go to the View tab in the ribbon.
  • From the Workbook Views group, select Page Layout.

  • As a result, you will see the dataset on one page only. See the screenshot.

Excel Page Layout View One Page Only


Things to Remember

  • In the case of the page setup method, we can adjust our dataset on one page for both portrait and landscape orientations.
  • If you resize the column width and row height properly, wrap text can be a perfect solution to show the page layout view on one page.

Download Practice Workbook

Download the practice workbook below.


Conclusion

To show the page layout view on one page only, we have shown four different methods through which you can keep your data on one single page. All of these methods are helpful and can be a valuable asset for day-to-day work. I hope we covered all possible solutions in this article. If you have further questions, feel free to ask in the comment box.


Related Articles

Durjoy Paul
Durjoy Paul

Hi there! I'm Durjoy. I have completed my graduation from the Bangladesh University of Engineering and Technology. I am working and doing research on Microsoft Excel and here I will be posting articles related to it.

2 Comments
  1. None of these work

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo