How to Fit to Page in Excel (3 Easy Ways)

Get FREE Advanced Excel Exercises with Solutions!

A worksheet’s content may fill more than one page when printed, in which case the extra columns or rows must be printed on a separate sheet of paper. It is not economical to print one column or one row on a sheet of paper. There is a possible solution to resizing Excel’s print area such that it will fit all of the text on one page. In this article, we will show you how to Fit to Page in Excel.


3 Handy Approaches to Fit to Page in Excel

Typically, Excel spreadsheets don’t print the way you want them to. If you’re lucky, your spreadsheet’s rows and columns will all exactly match the size of the printed page, but more often than not, one column or one row will result in the addition of an extra page or even a double-digit increase in the number of pages. In the following ways, we will demonstrate how to fit a page in Excel by utilizing Page Layout, tab using Print Preview Screen, and applying VBA Code. Let’s suppose we have a sample data set of multiple rows and columns.

Sample Data


1. Utilizing Page Layout Tab to Fit to Page in Excel

In this first method, you will learn how to Fit to Page in Excel utilizing the Page Layout tab.

Step 1:

  • First, select the Page Layout tab.
  • Then, click on the marked sign which is indicated by position 2.

Sample Data

Step 2:

  • Now, the Page Setup panel will open.
  • And then, click on the Fit to option choosing page wide by 1 and tall by 1.
  • Finally, click OK.

Sample Data

Step 3:

  • Here, you will see the final outcomes of the worksheet all on one page to fit to be printed.

Sample Data

Read More: How to Change the Printing Scale So All Columns Will Print on a Single Page


2. Using Print Preview Screen to Fit to Page in Excel

In this method, we will demonstrate how to Fit to Page in Excel when scrolling using the Print preview screen window.

Step 1:

  • At the start of this section, navigate to the File tab.

Handy Approaches to Fit to Page in Excel

Step 2:

  • Now, go to the Print tool.
  • Then, select the No Scaling option.
  • Besides, click on the Fit Sheet on One Page option.

Handy Approaches to Fit to Page in Excel

Step 3:

  • Finally, the worksheet’s results are displayed here on a single page that is suitable for printing.

Handy Approaches to Fit to Page in Excel

Read More: Excel Fit to Page Scale/Preview Looks Small


3. Applying VBA Code to Fit to Page in Excel

In this last section, we will generate a VBA code utilizing the Developer tab to Fit to Page in Excel.

Step 1:

  • At first, we will use the Developer tab.
  • Then, we will select the Visual Basic command.

Handy Approaches to Fit to Page in Excel

Step 2:

  • Here, the Visual Basic window will open.
  • After that, from the insert option, we will choose the new Module to write a VBA Code.

Handy Approaches to Fit to Page in Excel

Step 3:

  • Now, paste the following VBA code into the Module. To run the program, click the “Run” button or press F5.
Sub Fit_to_Page()
Dim Mysheet As Worksheet
Set Mysheet = ThisWorkbook.ActiveSheet
'PageSetup allows to configure different printing settings in their configuration
With Mysheet.PageSetup
'Data set will be printed in landscape orientation without zoom
.Orientation = xlLandscape
.Zoom = False
'One page for height
.FitToPagesTall = 1
'One page for wide
.FitToPagesWide = 1
'Print area will be specified
.PrintArea = "A1:E26"
End With
'Any sheet for printing
Set Mysheet = Nothing
End Sub

Handy Approaches to Fit to Page in Excel

VBA Code BreakDown

  • Firstly, we call our Sub Procedure Fit_to_Page_Folder.
  • Then, we refer to our current Worksheet as Active Worksheet.
  • Now, we choose Page_Setup which allows configuring different printing settings in their configuration.
  • Then, we specify our landscape orientation using Orientation = xlLandscape.
  • Again, we specify our pages height and wide on one page to fit using FitToPagesTall = 1 and FitToPagesWide = 1.
  • Finally, we specify our print area using PrintArea = “A1:E26”.

Step 4:

  • Here, you will see the results of the worksheet on one printable page.

Handy Approaches to Fit to Page in Excel

Read More: How to Adjust Page Size for Printing in Excel


Download Practice Workbook

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


Conclusion

In this article, I’ve covered 3 handy methods to Fit to page in Excel. I sincerely hope you enjoyed and learned a lot from this article. If you have any questions, comments, or recommendations, kindly leave them in the comment section below.


Related Articles

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.
Bishawajit Chakraborty
Bishawajit Chakraborty

Bishawajit Chakraborty, a Rajshahi University of Engineering & Technology graduate with a B.Sc. in Mechanical Engineering, has been associated with ExcelDemy since 2022. Presently, he is a content developer, specializing in Excel Power Query, Data Analysis and VBA. It is worth mentioning that he has authored more than 90 articles on VBA content development. His profound interest lies in the fields of data analytics and data science. He possesses expertise in VBA, Power BI, machine learning, and Python... Read Full Bio

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo