How to Print an Excel Sheet in A4 Size – 4 Methods

The following sample dataset has a large column width.

4 Ways to Print Excel Sheet in A4 Size


Method 1 – Printing an Excel Sheet in A4 Size Using the Page Layout Tab

Steps

  • Go to Page Layout, click the small arrow sign at the corner of Page Setup.

Print Excel Sheet in A4 Size by Using Page Layout Tab

  • In the new window go to Page.
  • In Scaling, choose Fit to and enter 1. In page wide by enter 1.
  • Select A4 in Paper size and click OK. 

Print Excel Sheet in A4 Size by Using Page Layout Tab

  • Press Ctrl+P to open the print preview. Click Print to print the sheet in A4 format.

Read More: How to Print Excel Sheet in Full Page


Method 2 – Defining Size to Print an Excel Sheet in A4 Size

Steps

  • Go to the Page Layout tab. In Page Setup, click Size.
  • Select A4 from the dropdown menu.

  • Press Ctrl+P to open print preview. Click Print.

Defining Size to Print Excel Sheet in A4 Size

Read More: How to Print Sheet on One Page in Excel


Method 3 – Defining the Page Size in the Print Preview Window

Steps

  • Open the Print Preview by pressing Ctrl+P.
  • Click paper size.

Defining Size to Print Excel Sheet in A4 Size

  •  Select A4.

  • This will set page settings to A4.  Check the margins and the scaling to keep all columns and rows on one page.

Defining Size to Print Excel Sheet in A4 Size

  • Click Print.

Read More: How to Print Multiple Sheets in Excel


Method 4 – Scaling Data and Printing a Sheet in A4 Size

Steps

  • Go to Page Layout > Orientation > Landscape.

Scaling the Data to Print Sheet in A4 Size

  • Go to the print preview select A4.
  • Select Fit all columns in One Page or Fit Sheet for One Page.

Read More: How to Print Excel Spreadsheet on Multiple Pages


Download Practice Workbook

Download this practice workbook.


Related Articles


<< Go Back to Print in Excel | Learn Excel

Get FREE Advanced Excel Exercises with Solutions!
Rubayed Razib Suprov
Rubayed Razib Suprov

Rubayed Razib, holding a BSC degree in Naval Architecture & Engineering from Bangladesh University of Engineering and Technology, serves as a devoted member of the ExcelDemy project. He has contributed significantly by authoring numerous articles and showcasing proficiency in VBA. Razib efficiently automates Excel challenges using VBA macros and actively participates in the ExcelDemy forum, providing valuable solutions for user interface challenges. Apart from creating Excel tutorials, he is interested in Data Analysis with MS Excel,... Read Full Bio

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo