How to print Excel spreadsheet on one page Landscape

Sometimes you may want to see the whole dataset on one page but just for one or two extra columns or rows, you have to deal with multiple pages. If you know some easy tricks, then

How to print Excel spreadsheet on one page Landscape

Sometimes you may want to see the whole dataset on one page but just for one or two extra columns or rows, you have to deal with multiple pages. If you know some easy tricks, then you can easily avoid this kind of issue. In this article, you will learn how to print the Excel sheet on one page in 9 easy and effective ways.


Table of Contents hideDownload Workbook9 Ways to Print Excel Sheet on One Page1. Print Excel Sheet on One Page by Adjusting the Column Width or Row Height2. By Changing the Scaling to Fit All Rows or Columns of Excel Sheet on One Page3. By Hiding or Deleting Unnecessary Rows or Columns from Worksheet in Excel4. Print Excel Sheet on One Page by Changing the Page Orientation5. Change the Page Margins to Print Excel Worksheet on One Page6. By Reducing the Font Size to Fit Spreadsheet on One Page in Excel7. Print Excel Sheet on One Page by Wrapping Text and Resizing Columns8. By Selecting Only the Necessary Data to Print on One Page in Excel9. Print Spreadsheet on One Page by Inserting Page Break in ExcelConclusionRelated Articles

Download Workbook

You can download the free practice Excel workbook from here.Print Excel Sheet on One Page.xlsx


9 Ways to Print Excel Sheet on One Page

In the following section, we will discuss various ways how you can optimize your Excel spreadsheet and fit it into one page while printing.

1. Print Excel Sheet on One Page by Adjusting the Column Width or Row Height

Excel has an auto-generated column width or row height which sometimes are not needed. You can simply reduce the column width or row height to shrink data on the worksheet so that the sheet could be printed on one page.

But how do you know the amount of space that you can reduce so that the data of the cells wont be affected? How can you know whether you have shrunk enough or not?

To know that easily, you can utilize the Page Layout option from the View tab in Excel.

Steps to know the column width from the Page Layout option are given below.

Steps:

  • Go to the View tab, then select Page Layout.
print excel sheet on one page from page layout

This will change how the sheet is being displayed. You will be able to see the scales at the top and the left side of the spreadsheet.

  • You can place the cursor of your mouse at the edge of the column that you want to reduce the size. Then click and drag the cursor to reduce the size of the column.
adjusting column to print excel sheet on one page
  • Similarly, you can reduce the row height by placing the cursor of your mouse at the edge of the row number that you want to reduce in size and simply click and drag.
adjusting row to print excel sheet on one page

By doing so, you can save a lot of space in your Excel sheet. It will eventually shrink the sheet to let it fit on one page which will be easier to print later.

Read More: How to Adjust Print Settings in Excel (8 Suitable Tricks)


2. By Changing the Scaling to Fit All Rows or Columns of Excel Sheet on One Page

Excel has a built-in option to rescale the worksheet to fit more rows or columns on one page. With this option, you can simply scale down the data of your worksheet to fit everything on one page.

Below are steps on how to do that in Excel.

Steps:

  • Click on the File tab.
  • Select the Print option or press Ctrl + P from the keyboard.
  • From the Print window, select the No Scaling option.
  • It will open a list of options, from where you can choose the option that you need.
print excel sheet on one page By Changing the Scaling

It will scale the sheet based on the option you selected to fit the sheet on one page. When you select the option you get to see how the data will appear in the sheet preview on the right side of the Print window.

Read More: How to Print Excel Sheet in Full Page (7 Ways)


3. By Hiding or Deleting Unnecessary Rows or Columns from Worksheet in Excel

You can hide or delete any unnecessary rows or columns from the worksheet. If you dont need any columns or rows then you can delete those, but if you only need to print some specific data then you can hide the rest and after printing, you can visible those again.

  • To hide a row or column, simply select them, then right-click and select Hide.
print excel sheet on one page by hiding data
  • To delete any unnecessary row or column, simply select them, then right-click and select delete from the options.

By doing so, you are able to optimize the space and use fewer pages to print.

Related Content: How to Set Print Area in Excel (5 Methods)


4. Print Excel Sheet on One Page by Changing the Page Orientation

If you have rows or columns that are way more than the spreadsheet can display perfectly, you can change the orientation of the sheet while printing.

There are two orientation options available in Excel,

  • Portrait  Default; One page can print more rows than columns.
  • Landscape  One page can print more columns than rows.

How you can change page orientation in Excel is shown below.

Steps:

  • From the tabs, click the Page Layout.
  • From the Page Setup group, click on the little arrow sign on the right bottom corner of the ribbon. This will bring up the Page Setup dialogue window.
  • In the dialogue window, you will see there are Portrait and Landscape Orientation options under the Page tab.
print excel sheet on one page by Changing the Page Orientation
  • You can select any options from them according to your need. After checking Portrait or Landscape, you can also further scale it by checking the Fit to option and providing the value based on the requirements.
  • Click OK. You can then go to the Print Preview window to check what your page will look like after printing.

Read More: How to Fit to Page and Print in Excel (10 Ways)


5. Change the Page Margins to Print Excel Worksheet on One Page

Sometimes all you need to squeeze the dataset a little more so that just one or two extra columns can be fit on one page. A little adjustment in the Page Margins may get that job done.

In case you dont know what Page Margin is in Excel  for better readability, every printed page have some whitespaces at the edges which are called Page Margins.

You can reduce this white space (page margin) to fit more data on a single page.

Below are the steps on how you can reduce page margins in Excel.

Steps:

  • Among the tabs, click the Page Layout.
  • From the Page Setup group, click on Margins.
  • Then select Narrow.
Change the Page Margins to Print Excel sheet on One Page

This will reduce the page margins and you may notice some extra rows or columns being squeezed on one page.

  • If you still want to reduce more then you can click on the Custom Margins.

This will open the Page Setup window where you can further modify the margins.

Read More: How to Print Selected Area in Excel on One Page (3 Methods)


Similar Readings:

  • How to Print to PDF in Excel VBA : With Examples and Illustrations
  • How to Print Labels in Excel (Step-by-Step Guideline)
  • Excel VBA Debug Print: How to Do It?
  • How to Center the Print Area in Excel (4 Ways)
  • How to Print Titles in Excel (5 Easy Ways)

6. By Reducing the Font Size to Fit Spreadsheet on One Page in Excel

When the data are spilling into other sheets while printing, another smart way to make some extra rooms on one page is by simply reducing the font size.

This will allow you to have some extra spaces in columns so that you can reduce the size of those columns and fit data on one page while printing.

Read More: How to Print Worksheet with Comments in Excel (5 Easy Ways)


7. Print Excel Sheet on One Page by Wrapping Text and Resizing Columns

Suppose you have a dataset where the texts in your cells are so big that they stretch out your worksheet and make it difficult to fit on one page while printing.

To reduce the width of the spreadsheet, you can use the Excel Wrap Text feature and then reduce the width or height of your columns or rows. Wrapping text first will make sure that you wont lose any data when you reduce the size of the rows or columns; hence it will print the data of the sheet perfectly on one page.

How you can wrap the text and later reduce the column or row size is shown below.

Steps:

  • Select the cell first that you want to squeeze.
  • In the Home tab, select Wrap Text from the Alignment group.
Wrapping text to print excel sheet on one page

By doing so, when Excel finds a text in a cell that is wider than the column width, this process will wrap the text down to the next line. You can then adjust the size of the row or column according to your need by dragging the edge of the row or column.

Read More: How to Set Print Preview in Excel (6 Options)


8. By Selecting Only the Necessary Data to Print on One Page in Excel

Sometimes you may want to print only some specific data from your spreadsheet, not the whole large dataset that your worksheet holds.

In this case, you can quickly print the specified data of your worksheet by following the steps below.

Steps:

  • Select the data that you want to print on one page.
  • From the tabs, click the tab File.
  • Then click on the Print option.
  • Under the Setting group, click the arrow sign beside Print Active Sheets.
  • From the appeared option list, select Print Selection.
Selecting Only the Necessary Data to Print on One Page in Excel

You will notice that the preview on the right side of the window is also changing based on the selection.

Then simply Print the sheet. These steps will print only the selected area.

Read More: How to Print Data with Excel VBA (A Detailed Guideline)


9. Print Spreadsheet on One Page by Inserting Page Break in Excel

When you have a large dataset, its obvious that it wont fit into one page. So while printing, it would take multiple pages to cover the entire dataset.

In this case, you can utilize Excels Page Break feature to let Excel know where to stop when printing the current page and pass the rest of the data to the next page.

The steps to insert page breaks in Excel are given below.

Steps:

  • Select the cell where you want to divide the sheet. From that cell onwards, everything on that sheet will be printed on the next page.
  • In the Page Layout tab, under the Page Setup group, click the Breaks option.
  • Select Insert Page Break.
Print sheet on One Page by Inserting Page Break in Excel

This will apply a four-directional line from the cell selected.

It means the above data from the line will be printed on one page and the rest will be printed on another page.

Read More: How to Print Excel Sheet in A4 Size (4 Ways)


Conclusion

There are various ways that you can apply when you want to print the Excel sheet on one page while printing a large dataset. This article showed you how to do that in 9 different ways. I hope this article has been very beneficial to you. Feel free to ask any questions regarding the topic.


  • How to Print Page Number in Excel (5 Easy Ways)
  • Print Graph in Excel (5 Ways)
  • How to Print Multiple Sheets in Excel (7 Different Methods)
  • Print Specific Sheets Using VBA Macro in Excel (4 Ways)
  • How to Keep Header in Excel When Printing (3 Ways)

Video liên quan