How To Print Out More Rows In A Template Excel

If you oftentimes impress your data/work in Excel, I am sure you have faced the event where it prints multiple pages instead of one single page.

Sometimes, it's then frustrating that a new page is printed just to accommodate a few extra lines of data (which as well leads to wastage of paper).

There are some elementary techniques you can use to make sure yous Excel data in printed on one page (or in less number of pages in case y'all're printing a big report).

In this Excel tutorial, I volition share some methods you lot tin can utilise to impress the Excel sail on one page. You lot can utilise a combination of these methods to get the all-time upshot.

Then let's get started!

Bank check How Many Pages Would be Printed (Preview)
Ways to Fit and Print Excel Sheet in I Folio
- Adjust the Column Width (or Row height)
- Change the Scaling (Fit All Rows/Columns in One Page)
- Hide or Delete Rows/Columns
- Alter the Page Orientation
- Change the Page Margins
- Reduce the Font Size
Print Selected Information only (or Set the Print Area)
[Bonus] Add Page Breaks

Check How Many Pages Would be Printed (Preview)

Before y'all set out to optimize the settings to print the Excel piece of work in one canvass, it's best to bank check the current state using the Print Preview.

Don't worry! Yous don't have to print anything for this. You tin can only check how the printed work would wait and how many sheets will be printed.

This allows you to sympathise the things you tin can alter to make sure you're using the minimal number of paper while yet keeping your printed report cute and legible.

Below are the steps to use Print Preview to run into how the final impress job would look like:

Click the File tab
Click the Print Option

Or you tin use the keyboard shortcut Command + P (Control + P if using a Mac)

This would open the Impress preview page where yous would be able to see how many pages would be printed and what would be printed on each page.

You can use the pointer keys to get to the next/previous folio when in the Print preview manner.

Means to Fit and Impress Excel Sail in One Page

Now, permit's come across some methods y'all can apply to fit all the data in a sheet on i page and then print your study on one page (or fewer number of pages)

Adjust the Column Width (or Row height)

In many cases, you don't need your columns to exist too wide.

And since this is a direct determinant of how much data is printed on 1 page, yous can salvage a lot of paper past simply reducing the column width.

Merely then, how do you know whether you lot have done plenty or not? How do you know how much column width yous should reduce to make everything fit on one folio?

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

Beneath are the steps to get into the Page Layout mode so reduce the cavalcade width:

Click the View tab in the ribbon
In the Workbook Views group, click on the 'Folio Layout' choice. This volition change the way information is displayed (and you lot will see scales at the meridian and on the left of the worksheet)
Reduce the column width to fit the data on i page. To practise this, place the cursor at the edge of the cursor on the column header that you want to reduce in size. And so click and drag.

Once you lot accept all the information on one page, you tin go alee and impress it.

In some cases, yous may find that the information in a jail cell is being cut off and is not being displayed completely. This often happens when you change the column width. Yous can right this by enabling the Wrap text option in Excel.

To render to the normal view (and go out of the Page Layout view), click on the View tab and then click on 'Normal'.

Change the Scaling (Fit All Rows/Columns in One Page)

Excel has an in-congenital option that allows you lot to rescale the worksheet in a manner that fits more than rows/columns on 1 folio.

When you exercise this, it simply scales down everything to fit all the columns or rows in one page.

Suppose you take a sheet where the columns are spilling over to the next sheet when printed.

Below are the steps to calibration downwards the canvas while printing:

Click the File tab
Click on Impress (or use the keyboard shortcut – Control + P)
In the Print window, click on the Scaling option (it's the last option on the left)
Click on any one of the options:
- Fit Sheet on One Folio
- Fir All Columns on One Page
- Fit All Rows on One Page

The above steps would calibration the sheet to fit the page (based on what options you lot accept selected). Y'all volition likewise be able to meet how the data would look in the sheet preview which is on the right.

The 'Fit Sheet on One Folio' option is suited when you lot but have a few rows/columns that are spilling over. In case there are many, using this option may make the printed data too modest to read.

This doesn't impact the worksheet data. It only scales the data for print purposes.

Hide or Delete Rows/Columns

Another smart manner to become everything on one page when printing is to hide whatsoever columns or rows that y'all don't need.

You always have the option to make these visible again in instance you demand it later, but hiding these while printing volition brand sure you're optimizing the infinite and using fewer pages to impress.

To hide a row/cavalcade, simply select them, right-click and then select Hide.

Again, it's best to commencement get into the Page Layout mode and and then exercise this. This makes sure yous can see how many rows/columns y'all need to hide to fit all the information on ane page in Excel.

And here are steps to unhide the rows/columns in Excel.

Modify the Page Orientation

If you have more columns and rows, it makes sense to alter the orientation of the folio while printing.

There are two Orientations in Excel;

Portrait (default in Excel) – More than rows are printed than columns
Landscape – More columns are printed than rows

In case you accept more columns than rows (as shown below), you can change the page orientation to Mural to ensure your data fit and is printed on 1 page.

Below are the steps to modify the page orientation in Excel:

Click the Folio Layout tab
In the Folio Setup grouping, click on the dialog box launcher. This volition open the 'Page Setup' dialog box.
Click on the Page tab in the dialog box (if non selected already)
In the Orientation selection, select Landscape
Click OK

At present you can go to Impress Preview and come across how your printed written report would look like.

The keyboard shortcut to open the Folio Setup dialog box ALT + P + S + P (press these keys in succession)

Alternatively, you can too change the orientation in the Print Preview window, past selecting Landscape Orientation from the drop-downwards in the settings.

Change the Page Margins

Sometimes you just have ane or two actress columns that are getting printed on a new page (or a few extra rows that are spilling to the next folio).

A picayune aligning in the Page margins may assist y'all fit everything on a single page.

If you're wondering what page margins are – when y'all print an Excel worksheet, every printed folio would have some whitespace at the edges. This is by design to make sure the data looks good when printed.

Yous have the option to reduce this white space (the page margin) and fit more information on a single folio.

Beneath are the steps to reduce the folio margin in Excel:

Click the Page Layout tab
In the Folio Setup grouping, click on 'Margins'
Click on Narrow

The above steps would reduce the page margin and you may come across some extra rows/columns being squeezed on the aforementioned page.

In case you want to further reduce the page margin, click on the 'Margins' option in the ribbon, and so click on 'Custom Margins'. This will open up the Folio Setup Dialog box where you can farther adjust the margins.

Reduce the Font Size

Another simple fashion to chop-chop make some extra rows/columns (that are spilling to additional sheets when printed as of now) fit the same page can be past reducing the font size.

This can permit you to resize a few columns so that information technology fits one page when printed.

This can exist useful when y'all have printed data that normally goes in the appendix – something you need to have but nobody reads or cares near it.

Print Selected Data only (or Set up the Impress Area)

Sometimes, you may have a large dataset, but y'all may non want to print all of it. Possibly yous only want to print selected data.

If this is a one-off thing where you desire to chop-chop print the selected data in the worksheet, you can do that using the below pace:

Select the data that you want to print
Click the File tab
Click on Print (or use the keyboard shortcut – Control + P)
In the Print screen that shows upwards, click on the first selection in Settings
Click on the Impress Selection option. You would notice that the preview too changes to prove you lot only the office that would be printed.
Click on Print.

The above steps would only impress the selected dataset.

Note that in case you selected a dataset that can't be fit into a single plage when printed, it will be printed on multiple sheets. You can, however, change the scaling to 'Fit Canvas on 1 Page' to impress pick on a single page.

The above method is adept when yous have to print the selected data once in a while.

Just you demand to impress the same pick from multiple worksheets, it's a ameliorate idea to prepare the print expanse. Once prepare, Excel would consider this Print Expanse as the function that is meant to print and would ignore the other information on the sheet.

Below are the steps to set the print expanse in Excel:

Select the data that you desire to set up every bit the print area
Click the Folio Layout tab
In the Page Setup group, click on the Impress Area option
Click on Set Print Expanse

That's it!

Now when you try and print a worksheet, simply the print surface area would be printed (and simply this will be shown in the Impress Preview).

[Bonus] Add together Page Breaks

In case y'all accept a large dataset. it's obvious that it can not be fit into one page and press this entire data would take up multiple pages.

You can add page breaks in Excel to let Excel know where to cease printing on the electric current page and spill the balance to the next folio.

Below are the steps to add page breaks in Excel:

Select the cell where you want to insert the page break. From this cell onwards, everything would be printed on the adjacent page
Click the Page Layout tab
In the Page Setup grouping, click on Breaks selection
Click on Insert Page Breaks

The above steps would add a folio interruption and everything before the page break would exist printed in one sheet and the remaining information in other sheets.

Note that in instance you have set the print area, it will take precedence over page breaks.

Then these are various methods you tin utilise to fit data into one folio and impress an Excel spreadsheet on one page. In cases where yous take a lot of data, information technology may not make sense to print it on 1 page, just you can yet employ the above methods to minimize newspaper usage and fit the same data into fewer pages.

I hope you institute this tutorial useful.

You may besides like the following Excel tutorials:

How to Impress Comments in Excel
How to Impress the Top Row on Every Page in Excel
How to Impress Multiple Sheets (or All Sheets) in Excel in I Go
How to Unhide COLUMNS in Excel
How to Group Worksheets in Excel
How to Compare Two Excel Sheets (for differences)