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.
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.