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

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



PRIME MEMBER EXCLUSIVES: Find these Amazon Prime-member exclusive deals on speakers, smart TVs, smart watches and more!

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.

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.

AMAZON TRADE-IN DISCOUNTS: Trade in & save on a new Fire TV device now!


More From

Find Tracks by Searching Using Actual Song Lyrics on Spotify

You are walking in the mall and suddenly, you hear a new song. It suits your taste in music. The lyrics and tune are...

How to Properly Set up & Connect to a VPN on Windows 10 or 11

Using the Internet has become a part of our everyday lives. We use it to search for something, look for food options, access our...

How to Add or Update your Default Payment Method on Venmo

If you have been avoiding using cash in all your payment transactions, Venmo is an excellent alternative. Using the Venmo mobile app, you can...

How to Fix Netflix Error Code tvq-st-141, tvq-st-142 or UI-502

Streaming on Netflix can give you hours of entertainment. You can binge-watch popular series or watch old and new movies on Netflix. However, there...


Please enter your comment!
Please enter your name here

Recent Articles

Stay Connected