How to Print Excel Sheet on One Page

This is a question that is often asked (How to Print Excel Sheet on One Page), namely how to fit the contents of one’s spreadsheet on one page when printing.

So we are going to look at three ways of achieving just that.

Read More: How Excel Handle Charts, Embedded Charts, and Chart Sheets

Introduction

A hypothetical salesperson is looking at the sales data for the year 2016, for a certain region. The spreadsheet contains text in cells, a chart, and an Excel Table as shown below.

How to Print Excel Sheet on One Page - Image 1

How to Print Excel Sheet on One Page

#Evaluating the Spreadsheet Using Print Preview First

1) The salesperson ideally wants to print all the data in the current sheet (text, chart, and Table) on one page. So the first thing to do is look at the current Print Preview.

2) Go to File>Print in order to see what the worksheet with the above data, will look like if printed.

Excel Preview Image 2

Excel Preview Image 3

3) The data is printing across two pages as shown in the Print Preview with part of the chart spread across two pages, and ideally, we want the spreadsheet with all the data printed on one page.

#Changing the Width in the Scale to Fit Options

1) One way of achieving this is by going to Page Layout>Scale to Fit and changing the width in this case, since all the columns are not being accommodated, from Automatic to 1 Page as shown below.

Sales Data Image 5

2) If we go to Print Preview now, by going to File>Print, we can now see that the spreadsheet will print on one page.

Print Preview in Excel

#Changing the Page Orientation

1) Another way of accomplishing the above without changing the Scale to Fit Options, is by changing the Page Orientation, to Landscape, again this is in the case of where the columns are not fitting on one page, the most common scenario.

Read More: 10 Amazing Tips to Print Data in Excel Without a Headache

2) In order to do this, go to Page Layout>Page Setup>Orientation and change the Orientation from Portrait to Landscape.

Landscape View of Spreadsheet Page

3) Going to Print Preview by going to File>Print, we can now see that the spreadsheet is printing on one page.

Print Preview Excel Image 7

4) This solves the printing on the one-page issue, however, if one turns on margins, in the Print Preview, we can see that the data is not evenly printing across the page, it is taking up the left side mainly.

Print Preview in Excel

5) In order to distribute the data more evenly on the page, go to Page Layout and expand the Page Setup section, in order to launch the Page Setup Dialog Box.

Page Layout in Excel - Image 10

6) Select the Margins Tab and check the Center on Page Horizontally option as shown below.

Page Setup Dialog Box

7) Selecting the Print Preview option shows that the data is more evenly distributed across the page.

Print Preview in Excel

Generally, there are times when one may need to change both the width and the height to one page, however, this can make the data difficult to read since the scaling reduces the size of all the data to fit on one page.

#Scaling the data to fit on one page using the Fit Sheet on One Page option

As mentioned above, one can use the Fit Sheet on One Page option.

Read More: How to Use Form Controls in Excel

1) Using our original source worksheet, we go to File>Print in order to see the Print Preview and the default setting is No Scaling as shown below.

Print Preview in Excel Image 11

2) One can change this by selecting Fit Sheet on One Page as shown below.

Print Preview in Excel Image 12

3) The effect of this can be seen on the scaling of the page, and the reduction of the number of pages needed for printing. Additionally, by going to Page Layout>Scale to Fit – one now sees both the width and the height options have been set to one page by choosing this option.

How to Print Excel Sheet on One Page - Image 13

However, as mentioned this scaling option should be utilized with caution and depending on the data in the worksheet since it can sometimes reduce the size of the data on the page to the point where readability and legibility become difficult.

Download Worksheets

HowToPrintASpreadsheetonOnePageinExcelChangingFittoOnePage

HowToPrintASpreadsheetonOnePageinExcelChangingOrientation

HowToPrintASpreadsheetonOnePageinExcelChangingWidth

Conclusion

Printing an Excel spreadsheet on one page can be accomplished by either changing the width or the height. One can also adjust the Page Orientation and change it from the default Portrait to Landscape orientation.

Please feel free to comment and tell us the printing options you frequently use in order to accommodate data in your spreadsheet.

Useful Links

Scale a worksheet

Taryn is a Microsoft Certified Professional, who has used Office Applications such as Excel and Access extensively, in her interdisciplinary academic career and work experience. She has a background in biochemistry, Geographical Information Systems (GIS) and biofuels. She enjoys showcasing the functionality of Excel in various disciplines.

In her spare time when she’s not exploring Excel or Access, she is into graphic design, amateur photography and caring for her two pets, Pretzel and Snoopy.

You may also like...

Leave a Reply

Your email address will not be published. Required fields are marked *

Solve the Math * Time limit is exhausted. Please reload CAPTCHA.