HomeHow ToHow to Print & Fit Large Excel Sheet on Just One Single...

How to Print & Fit Large Excel Sheet on Just One Single Page

Author

Date

If we can make things look more beautiful, why not take the extra steps and do it? Sometimes, added effort on our part can make a difference in the outcome we want to achieve.

Take for instance, printing a Microsoft Excel sheet file. A spreadsheet document looks presentable enough to show various data and information. But, there are times when printing your worksheets out gives you blank spaces and empty rows. While it may seem natural, it can be improved by printing your multiple sheets out on just one single page.

Fit-Large-Excel-Sheet-on-Just-One-Single-Page
Image credit: our-team/Freepik

How to Print Multiple Sheets Microsoft Excel File & Fit them on Just One Single Page

Fortunately, there are several ways for you to do it. Check out the methods below and follow each of the steps one at a time to print a hard copy of your MS Excel worksheets.

Method #1 – Delete Empty Columns and Rows

One of the reasons why you end up with the second page of your spreadsheet is the extra rows and columns that take up space. What you need to do is to hide or delete them before printing. Deleting a row or column means that you want to eliminate it, including all values within it. Hiding a row or column simply hide them from view or printing, so you can get back to them when you need to.

  • First, look for the rows or columns that you want to delete or hide.
  • Click on the number or letter to highlight the entire row or column.
  • Right-click on it.
  • Select Hide or Delete. To show the hidden column or row, right-click on it again and select Unhide.

Method #2 – Choose a Different Page Orientation

There are two types of page orientation, Portrait, and Landscape. If you have more columns than rows, a good orientation is a Landscape. It will give your columns more space when printing. Otherwise, use the Portrait orientation.

  • On the menu bar, select the Page Layout tab.
  • Click Orientation.
  • Select Portrait or Landscape.

Method #3 – Change the Sizes of your Columns and Cells

A small adjustment can fit everything on one page. For instance, one of your columns may be spread wider than usual. If it is not necessary, you can adjust the size that will fit the text within it. Hover over to the side of the heading column until an arrow appears. Click and hold the arrow and move it according to the size you want.

Another way to fit the text in the cells is to wrap the text. Highlight the cells that you want to adjust. Click the Format tab and go to Wrapping. Select Wrap.

Method #4 – Make Adjustments Via Page Layout

If you want to see how your spreadsheet will appear on print, you can use the Page Layout view. That way, you will have a preview of your document while having the tools to make the necessary adjustments.

  • Navigate to the View tab on your menu bar.
  • Select Page Layout.
  • From there, you can check if your spreadsheet fits the number of pages that you desire. If not, make the adjustments using the various tools available. You can resize the columns and wrap the texts.

Method #5 – Print Only the Active Sheets

Excel enables you to select the pages that you want to print, so you will not have to waste any paper on empty rows and columns.

  • Click the File tab on the menu bar.
  • Select Print.
  • Go to the Settings menu.
  • Scroll down and select Print Active Sheets.

Were you able to fit your Microsoft Excel spreadsheet into a single page and print it? We would love to know your experience, so please share your story below.

Related

LEAVE A REPLY

Please enter your comment!
Please enter your name here

More From

How to Clear & Delete Cache Data on Xbox Series X or S Consoles

Just like any other device, your Xbox Series X/S console can become sluggish and perform less. The reason for it is often due to...

How to Pre-order the New Xbox Wireless Headset

With the latest release of Xbox Series X and Series S gaming consoles, Microsoft is supplementing it with the new Xbox Wireless Headset. It...

How to Fix Authy Verification Code Not Work­ing

Using two-factor authentication (2FA) codes gives us peace of mind when it comes to our online logins and passwords. 2FA codes add another layer...

How to Change or Cancel your Netflix Subscription

Streaming on Netflix gives you hundreds to thousands of movies and TV series episodes to choose from. You can binge-watch your favorite original shows...

Recent Articles

Stay Connected

Trending