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

Read More: What Is Page Layout View in Excel?


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


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


<< Go Back to Workbook Views | Workbook in Excel | Learn Excel

What is ExcelDemy?

ExcelDemy - Learn Excel & Get Excel Solutions Center provides online Excel training , Excel consultancy services , free Excel tutorials, free support , and free Excel Templates for Excel professionals and businesses. Feel free to contact us with your Excel problems.
Durjoy Paul
Durjoy Paul

Durjoy Kumar, with a BSc in Naval Architecture & Engineering from Bangladesh University of Engineering and Technology, is a dedicated contributor to the ExcelDemy project. His substantial contributions include crafting numerous articles and demonstrating expertise in Excel and VBA. Durjoy adeptly automates Excel challenges using VBA macros, offering valuable solutions for user interface challenges. Apart from creating Excel tutorials, he is interested in Data Analysis with MS Excel, SPSS, C, C++, C#, JavaScript, Python Web Scraping, Data Entry... Read Full Bio

4 Comments
  1. None of these work

  2. None of it works

    • Reply Lutfor Rahman Shimanto
      Lutfor Rahman Shimanto Feb 7, 2024 at 6:24 PM

      Hello BRYAN

      Thanks for visiting our blog. All the methods described in the article are working perfectly on our end. It is important to remember the intended effect you want to see when you have printed the sheet.

      OUTPUT OVERVIEW:

      So, I recommend you reread the article; good luck.

      Regards
      Lutfor Rahman Shimanto
      ExcelDemy

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo