How to Make Excel Spreadsheet Bigger When Printing (7 Ways)

You cannot make your Microsoft Excel spreadsheet bigger (unless you want to change the page size). But in this article, we will show some tips and tricks that you can use to print large datasets in a smaller space.


Make Excel Spreadsheet Bigger When Printing: 7 Easy Ways

Here’s an image of a worksheet. This data has 5 columns. So, it is tough to fit all these pages into 1 page.

 How to Make Excel Spreadsheet Bigger When Printing

In the following picture, we can see the page preview dotted lines. The last two columns will not print.

How to Make Excel Spreadsheet Bigger When Printing

To make an Excel spreadsheet bigger when printing, you can follow any of the ways described below.


Method 1 – Making Page Adjustments

Steps:

  • Go to the File tab.
  • Select the Print option.
  • Select the Letter option from the Settings section.

Making Page Adjustment

  • From the Letter option drop-down, select A3.

How to Make Excel Spreadsheet Bigger When Printing

In the Print Preview section, we can see that the entire dataset got adjusted on one page.

How to Make Excel Spreadsheet Bigger When Printing

Now, you can click on Print to print the entire dataset making the spreadsheet bigger when printing.

Read More: How to Print Multiple Sheets in Excel


Method 2 – Changing Orientation

Use print in landscape mode for higher column numbers and portrait mode for higher row numbers.

Steps:

  • Go to the File tab.
  • Select the Print option.
  • Select the Portrait Orientation option from the Settings section.

Changing Orientation

  • Select Landscape from the Orientation for our dataset.

How to Make Excel Spreadsheet Bigger When Printing

  • We can see that the entire dataset got adjusted on one page in the Print Preview section.

How to Make Excel Spreadsheet Bigger When Printing

Read More: How to Print Excel Spreadsheet on Multiple Pages


Method 3 – Applying Page Size Feature

Steps:

  • Click on the Page Layout tab.
  • Select Size from the Page Layout.
  • You can choose according to your demand from the page size options. Here, we have chosen A3 to keep all the columns on one page. You can also try the A4 sheet size for printing since it is the most popular sheet size.

Applying Size Feature

  • Now, if you print the entire dataset, you will see that all the columns are on one page. We can confirm that in the Print Preview section.

How to Make Excel Spreadsheet Bigger When Printing


Method 4 – Using Fit Sheet on One Page Option

Steps:

  • Go to the File tab.
  • Select the Print option.
  • Select the No Scaling option from the Settings section.

Using Fit Sheet on One Page Option

  • Pick Fit Sheet on One Page option from the No Scaling section.

How to Make Excel Spreadsheet Bigger When Printing

In the Print Preview section, we can see that the entire dataset got adjusted on one page.

How to Make Excel Spreadsheet Bigger When Printing

Read More: How to Print Excel Sheet in Full Page


Method 5 – Applying Print Area Command

Steps:

  • Select the entire area that you want to print. We have selected cells A1:G26.
  • Go to the Page Layout tab.
  • Select Print Area from the Page Layout ribbon.
  • Pick the Set Print Area option.

5. Applying Print Area Command

  • You can crossmatch whether the selected area is ready to print in the Print Preview section.

How to Make Excel Spreadsheet Bigger When Printing

Read More: [Fixed!] Excel Cutting Off Text When Printing to PDF


Method 6 – Using Page Break Preview Option

Steps:

  • Go to the View tab.
  • Select the Page Break Preview option from the View ribbon.

Using Page Break Preview Option

  • You will see a blue dotted line as the border between the pages.

How to Make Excel Spreadsheet Bigger When Printing

  • Extend the blue dotted line as far as you want to print the area on the first page.

Using Page Break Preview Option

  • The Excel spreadsheet got bigger. Confirm it in the Print Preview section.

Using Page Break Preview Option

Read More: [Fixed!] Cutting Off Columns when Printing


Method 7 – Reducing Page Margins

Steps:

  • Go to the File tab.
  • Select the Print option.
  • Select the Normal Margins option from the Settings section.
  • Choose the Narrow option to make the spreadsheet bigger.

Reducing Margins of Page


Download Practice Workbook


<< Go Back to Print in Excel | Learn Excel

Get FREE Advanced Excel Exercises with Solutions!
Kawser Ahmed
Kawser Ahmed

Kawser Ahmed is a Microsoft Excel Expert, Udemy Course Instructor, Data Analyst, Finance professional, and Chief Editor of ExcelDemy. He is the founder and CEO of SOFTEKO (a software and content marketing company). He has a B.Sc in Electrical and Electronics Engineering. As a Udemy instructor, he offers 8 acclaimed Excel courses, one selected for Udemy Business. A devoted MS Excel enthusiast, Kawser has contributed over 200 articles and reviewed thousands more. His expertise extends to Data Analysis,... Read Full Bio

1 Comment
  1. The Fit to option maxes out at 100%.

    To fit to one page when you want to increase the size past 100% I wrote this blog post that has macro code to achieve a fit to one page with greater than 100%. I also explained how I created the macro which is also instructive.

    https://a4accounting.com.au/expand-to-fit-to-one-page-in-excel/

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo