How to print Excel data on one page

We will learn how to print Excel on one page. You often print your Excel worksheet but you mostly face an issue where Excel data does not fit on one page. But it is very irritating for people that an extra page is printed to cover the few extra lines of data. We learn some methods to avoid the printing errors.

How to print Excel with lines

First of all, the best practice is to check the state stat using the preview.

Nothing to panic about! There is no need for you to print anything. You can just have a glimpse of the printed work and sheets too.

This helps you know what you can do to make certain that your printed document remains beautiful as well as readable, but uses the fewest number of pages possible.

Below are the steps showing how to use the Print Preview feature to view the final print job:

• Click on the File tab
• Click on the Print Option

You can also use the Excel shortcut key Control + P.

By clicking this, the Print preview page will be opened unveiling all pages to be printed and what will appear on each page.

Method to fit the Excel Sheet on a Page

Right now, we’ll go through several ways you can use to fit all data on a sheet into a page and later print your paper on one page (or even less).

Adjusting the Column Width (or Row height)

In many cases, it’s not necessary to make columns too wide.

And yet, this is what determines how much data is printed on one page of a paper and can therefore be used to save lots of papers by just reducing column widths.

But then, how do you know whether you have done enough or not? How do you know what column width should be reduced so that the whole content can fit in one page?

To make this easy, you can use the Page Layout View in Excel – which shows you in real-time how much data would be printed on each page of your report.

The following are steps to get into the Page Layout mode and reduce column width:

• Click on the “View” tab found on the ribbon
• Look for the “Page Layout” option in the Workbook Views group. It will change how data appears (you will also observe scales at the top and left of the worksheet).

Use the fit Sheet on one Page option  

To scale a worksheet when printing in Excel, or fit more rows or columns onto one page, do the following:

• Click on the File tab.
• Press Print (or use the shortcut Ctrl + P).
• You will find the scaling option at the far left of the print window.

Just select:

• Fit Sheet on One Page
• Fit All Columns on One Page
• Fit All Rows on One Page

This can help you shrink the content so that columns do not run over to additional pages once printed.

Having selected your options, the above steps would allow you to reduce or enlarge the sheet to fit it into a page. The right side of the preview for this spreadsheet shows how its data will appear in it.

Orientation

Orientation settings in Excel provide the flexibility to switch between Portrait Orientation, which displays more rows but fewer columns, and Landscape Orientation, which showcases more columns but fewer rows.

Page Margins option

To modify the margins, follow these steps.

• Select one of the preset margins (Normal, Wide, or Narrow) from the drop-down list of Margins.
• Alternatively, click on the ‘Show Margins’ icon at the bottom right of your window. You can then slide the lines to alter page margins manually.

Print Worksheet

To get the worksheet printed in Excel, follow these steps.

1. Click on the File tab and then click on Print.

2. To see what other pages will be printed out, there are ‘Next Page’ or ‘Previous Page’ buttons at the bottom of the window.

Click the Print button to print the worksheet.