How to Fit to Page in Excel - 3 Methods

The sample dataset contains multiple rows and columns.

Method 1 – Utilizing the Page Layout Tab to Fit to Page in Excel

Step 1:

Select the Page Layout tab.
Click the sign marked 2.

Step 2:

In Page Setup, click Fit to, choosing 1 in page wide by and 1 in tall.
Click OK.

Step 3:

This is the output.

Method 2 – Using the Print Preview Screen to Fit to Page in Excel

IStep 1:

Go to the File tab.

Step 2:

Select Print.
Choose No Scaling.
Click Fit Sheet on One Page.

Step 3:

This is the output.

Method 3 – Applying a VBA Code to Fit to Page in Excel

Step 1:

Go to the Developer tab.
Select Visual Basic.

Step 2:

In the Visual Basic window, select insert.
Choose Module.

Step 3:

Enter the following VBA code into the Module. To run the program, click “Run” 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

VBA Code Breakdown

calls the Sub Procedure Fit_to_Page_Folder.
refers to the current Worksheet as Active Worksheet.
chooses Page_Setup which allows configuring different printing settings.
specifies landscape as orientation, using Orientation = xlLandscape.
specifies the pages height and width, using FitToPagesTall = 1 and FitToPagesWide = 1.
specifies the print area, using PrintArea = “A1:E26”.