How to Print an Excel Spreadsheet on One Page (+ More)

Trying to fit your big spreadsheet into 1 tiny page?

As easy as it seems, printing Excel spreadsheets can be difficult if you don’t know the pro tricks. And even more so if you’re new to this software.

Luckily, this guide has everything you need to know about printing Excel spreadsheets. We’ve jotted down some of the most important Excel techniques to help you get started πŸ˜ƒ

So without further ado, let’s get right into it.

Also, if you want to practice along the guide, download our sample workbook here.

How to print an Excel sheet on one page

Sometimes we just want to squeeze all our data on one page to avoid extra mess. But by default, Excel prints multiple pages for data that can easily show up on a single page.

Not only does this lead to wastage of paper, but managing so many hard copies can be a true hassle.

This is why people prefer accommodating most of their data on a single page. And if you don’t have extensive data or readability issues, this is the ideal approach.

Let’s suppose we have some data set, and we want to print it on one page πŸ“„

Data for printing.

So to print the Excel sheet on one page:

  1. Click Print from the File Tab.
Print option from the file tab.
  1. The Print Preview screen shows up.
Print preview screen similar to page tab

The Print Preview screen gives you an idea of how your data will look on a printed page. Our printed page is in Portrait orientation and spread over two pages.

If you prefer, you can change the page orientation from the print settings shown above. Or the Page Layout Tab from the ribbon.

If you have columns to print, choose Landscape. And if the data consists of more rows (like in our case), choose Portrait.

Page layout to change page margins.

To fit all the rows on one page, we will scale it accordingly.

  1. Click the ‘No Scaling’ option at the bottom.
Using the Scaling option to avoid multiple sheets.
  1. Select ‘Fit All Rows on One Page.’
Choosing Scaling option from print options.
  1. Excel shows the preview as:
Print preview window with page breaks.

All your data will now be printed on a single piece of paper πŸ“

Note that scaling an Excel sheet on one page can make the printout hard to read.

Kasper Langmann, Microsoft Office Specialist

How to print the entire workbook

We just saw how to print the Excel spreadsheet on a single page. Now, let’s see how to print the entire workbook in one go.

It’s quite straightforward. All you need to do is:

  1. Go to ‘Print” from the File Tab.
  2. `Click ‘Print Active Sheets’ in the Print Preview area.
Selecting Print Active sheets
  1. Select ‘Print Entire Workbook.’
Printing workbook

Excel will now print the entire workbook when you click Print.

Pro Tip!

You can select other options too. For instance, if you only want to print a specific selection in the sheet, click ‘Print Selection.’ And if you want to print the Excel worksheet, select the ‘Print Active Sheets‘ option.

How to change the print area

As evident from the name, the Print Area lets you choose a specific portion of the spreadsheet that you want to print.

This is because often, we don’t want to print the entire sheet but only some part of it. The Print Area feature can help you do just that. And its working is similar to that of Print Selection under the Print Settings.

To enable the Print Area:

  1. Select the data you want to print.

We want to print the first ten rows of our data set:

Selecting data for Print Area
  1. Go to the Page Layout Tab.
  2. Select Print Area under the Page Setup group.
  3. Click ‘Set Print Area.’
Setting Print Area

And it’s done! πŸ₯³

Excel will now only print the selected data. You can view the Print Area in the Print Preview window as well πŸ—”

Print preview

Pro Tip!

You can also choose whether you want to show the gridlines for printing or not. For that, select the ‘Print’ option under Gridlines from the Sheet Options group.

Excel will now print the gridlines as well. You can view them from the Preview window.

You can also add a new print area to your previous selection. All you need to do is select the new range and press Print Area.

Then select the ‘Add to Print Area’ option.

Adding data to print area.

The selected portion is now added to the Print Area πŸ“ƒ

Similarly, if you want to remove it, click Clear Print Area. Excel will remove the entire Print Area.

How to print comments

If your comments are just as important as your worksheet data, know that you can print them too. The process takes a few seconds only and is easy to understand πŸ˜ƒ

To print Excel comments:

  1. Go to the Page Layout Tab.
  2. Open the Page Setup dialog box (from the small arrow at the right corner)
Page layout dialog box
  1. Click the Sheet tab.
Opening Sheet Tab
  1. Click the drop-down arrow next to Comments and select an option.
Selecting comments appearance.
  1. Press Ok.
Adding comments at end of paper

You can now see how the comments will appear on paper in the Print preview window πŸ“„

Just scroll down or move to the next page to view them.

That’s it – Now what

Printing spreadsheets in Excel can be tricky, especially when you have large data to print. But using these new techniques, you will be able to wind that hours-long task in minutes.

Summing up, we learned how to print an Excel sheet on one page in this article. We also saw how to print comments, the entire workbook, and even change the Print Area.

Knowing how to print Excel spreadsheets is pretty important when working in a professional environment. But so are the other things in this giant spreadsheet software that you need to learn!

If you are just starting out, we recommend you practice the Excel VLOOKUP, IF, and SUMIF functions. Enroll in my 30-minute free email course that teaches these functions and much more for FREE! 😡

Other resources

These printing tips and tricks are sure to give a boost to your Excel skills. All you need is constant practice and more knowledge.

If you enjoyed this article, we’re sure you’d love to know more. Try reading How to Print GridlinesMailing Labels, and more.

Frequently asked questions

To fit an Excel sheet on one page, go to File Tab Print. Click the No Scaling option at the bottom. Select ‘Fit Sheet on one Page‘ from the drop-down. Excel will shrink the printout to fit one page. You can also set custom scaling options to keep the data legible.

To print a selected area in Excel, open the Print option from the File Tab. Under Settings, click Print Active Sheets. Select ‘Print Selection‘ from the drop-down menu. Excel will now only print the range you have selected in the worksheet.

Clearing the Print Area in Excel is easy. Select Print Area under the Page Setup group from the Page Layout Tab and click Clear Print Area. Excel will remove the entire Print Area.