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

RECOMMENDED: Download this tool to help you safely fix common Windows errors & automatically optimize system performance

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.

STILL HAVING ISSUES? Try this tool to troubleshoot Windows errors and safely optimize system performance

Related

More From

How to Prevent Steam from Auto-Updating Games on PC

The Steam client automatically updates any game installed by default. Whenever, Steam starts with a network connection or if Steam is running, then updates...

How to Enable or Disable Automatic Downloads for You Netflix Feature

Long travels or regular commute may be boring you without any means of entertainment. However, not all transportation have Internet access or a stable...

How to Change Payment Method or Billing Address on Peacock

Peacock has several tiered plans available for users. Aside from its premium offerings, it also has an ad-supported free plan, a rare proposition in...

How to Use the Disney Plus GroupWatch Watch Party Feature

Watch Parties are getting popular these days. The times when you schedule a day with your friends to go to the movies together and...

LEAVE A REPLY

Please enter your comment!
Please enter your name here

Recent Articles

Stay Connected

Trending