Efficiently Print on Legal Size Paper in Excel: Expert Tips

Summary :

Ensuring that Excel content prints correctly on appropriately sized paper is crucial in the professional world. This article is a comprehensive guide to efficiently printing professional documents in Legal size in Excel, helping you quickly print contracts, legal documents, and other documents.

Table of Contents

Print on Legal Size Paper in Excel

Print on Legal Size Paper in Excel

Are you worried that the table has too many columns and cannot be displayed on standard letter paper, or that there is too much content and the font size is too small? Are you still troubled by the formatting or missing content after printing a document due to different paper sizes?

The best way to solve this kind of problem is to adjust the paper size in Excel to a legal size larger than A4.

In this article, we will explore in detail how to print on legal size paper in Excel and help you solve some common problems so that you can print your documents easily.

How to Print on Legal Size Paper in Excel

Many legal documents and professional reports contain a lot of content and tables with many rows and columns, but the general default paper cannot accommodate this content well. In this case, Legal size paper is more suitable.

Legal size paper measures 8.5 x 14 inches and can accommodate more content and notes due to more vertical space. Printing a document in Legal size in Excel ensures that a complete table will fit on one page, ensuring it looks beautiful and professional.

However, changing the paper size in Excel for printing can be challenging. Let’s discuss the specific and efficient methods below.

Step 1. Open the document you want to print in Microsoft Excel. And click “File”.

Open File Management

Open File Management

Step 2. Select “Print” in the left menu bar > Select “Legal” in the drop-down column of Paper Size in Print Setting to adjust the printing paper size to legal.

Print the Document in Excel

Print the Document in Excel

Step 3. But if you find that you still cannot accommodate all the columns, you can also choose to rotate the paper.

Select “Landscape Orientation” in the Orientation drop-down bar, and turn the paper to Landscape.

Rotate Paper to Print

Rotate Paper to Print

Step 4. In addition, you can also adjust the page margins to ensure that the table content is completely presented on the paper and displayed in the center.

Select “Custom Margins” in the drop-down bar of page margins > Customize the values of the top, bottom, left and right margins in the “Page Setup” pop-up window > Check the horizontal and vertical boxes in “Centre on Page” > Click “OK”.

Customize Paper Margins

Customize Paper Margins

Step 5. Select “Fit All Columns on one page” in the scaling drop-down bar.

Scaling to Fit the Paper

Scaling to Fit the Paper

Step 6. After confirming the document content displayed in the preview, click “Print” to print on legal size paper in Excel.

Print on Legal Size Paper in Excel

Print on Legal Size Paper in Excel

Fixed – “Legal” Paper Size Is Not Listed as an Option

When trying to print an Excel document, the “legal” paper sizes are sometimes not listed as the default options. This may be due to default print settings or printer driver limitations. If you encounter this problem, you can try the following.

Step 1. Open Windows Control Panel and go to “Hardware and Sound”.

Enter Windows Settings

Enter Windows Settings

Step 2. Open “Devices and Printers”.

View Printer

View Printer

Step 3. Right-click the printer you are using > click “Printer Properties”.

View Printer Properties

View Printer Properties

Step 4. Go to the “Advanced” tab in the printer properties pop-up window > select the new driver in the Driver drop-down bar > click “Apply”.

Update Printer Driver

Update Printer Driver

Recommended Printers for Legal Size Paper Printing From Excel

In addition to printing legal documents directly in Microsoft Excel, a suitable Excel printer is also a good choice. Next, we will recommend several Excel printers that combine quality, efficiency, and cost-effectiveness to meet various professional needs.

Product Pros Price
PDFgear Supports quick switching of paper sizes and unlimited, batch printing Completely Free
Google Sheets Cloud-based form processor with customizable print sizes Completely Free
LibreOffice Open-source office software can customize printing paper size, margins, table layout, etc. Completely Free

PDFgear

Although PDFgear is not a professional Excel spreadsheet processor, it provides a powerful format converter. Excel tables can be converted to PDF without changing the original format.

Supports printing in multiple sizes, including Legal size.

Its biggest feature is that it supports batch printing, making it the best choice for processing large batches of document printing jobs. And it’s completely free and can be used immediately without registration.

Google Sheets

Google Sheets is also one of the commonly used online spreadsheet processors, and any Excel spreadsheet can be opened through Google Drive. It supports printing a single worksheet or multiple workbooks, and you can also customize the paper size and whether to display grid lines and annotations. The best choice for collaborative work.

LibreOffice

LibreOffice is an open-source office software that can open .xls worksheets. And you can customize the paper size to Legal and set it as the default size. In addition, you can also quickly customize the page margins, paper direction, table layout, printing area, etc. Quickly complete the task of printing multiple forms on the same legal size paper.

FAQs

How Do I Change Print Settings to Print on Legal Paper Size?

Open the document > Go to “File” and select “Print” > Select “Legal” from the paper size drop-down bar in Print Setting > Print your document.

Can I Save My Excel Document Setup for Legal Size Paper as a Default Setting?

To set Legal size as Excel’s default paper size, you need to create a new Excel template file.

Create a new Excel table > Select “Page Layout” > Select “Legal” > Save as > Change the file name to “Book” and select “Excel Template” as the save type > Click “Save” > Move the saved file to the XLStart folder.

How Can I Ensure My Entire Excel Sheet Prints on One Page of Legal Size Paper?

To print an entire Excel sheet on one legal-size page, you need to adjust the orientation, margins, and zoom of the paper to fit the paper size.

Conclusion

Printing on legal size paper in Excel can be a challenging task, but with the guidance and solutions provided in this article, you can be sure to complete the task efficiently and accurately.

Choose the printer that best suits you to ensure a hassle-free printing experience and perfect presentation of your document.

More Related Articles

arrowtop