How to Print an Excel Spreadsheet on One Page: Easy Guide

Sharing is caring!

When you’re working with a large Excel spreadsheet, printing it can be tricky. By default, Excel might spread your data across multiple sheets of paper, making it hard to read and wasting paper. Fortunately, you can print an Excel sheet on one page by using Excel’s built-in scaling and Page Setup tools.

In this guide, we will explain step-by-step methods, useful tips, and formatting tricks to make your printouts look neat and professional.

Why You Might Need to Fit an Excel Sheet on One Page

When printing reports, invoices, budgets, or project trackers, having your data fit on a single sheet helps with:

• Readability – Everything is in one place, so your audience doesn’t have to flip pages.
• Professional presentation – Clean, single-page reports look more polished.
• Saving paper – You use fewer pages, which is better for cost and the environment.

Whether you’re using Microsoft Excel 365, Excel 2021, Excel 2019, Excel 2016, or Excel for Mac, the process is very similar.

Step-by-Step: Printing an Excel Spreadsheet on One Page

1. Open the Page Layout Tab

• Open your Excel workbook.
• Go to the Page Layout tab from the ribbon menu.
• This tab contains page size, margins, orientation, and scaling options.

2. Access Page Setup

• In the Page Setup group, click the small arrow in the bottom-right corner.
  This opens the Page Setup dialog box.
• Alternatively, you can go to File > Print and then click Page Setup from the print preview window.

3. Adjust Scaling Settings

• In the Page Setup window, select the Page tab.
• Under Scaling, choose Fit to.
• In the “Pages wide” box, enter 1.
• In the “Pages tall” box, also enter 1.
  This tells Excel to shrink or expand your worksheet so it fits exactly on one sheet of paper.

Example Table of Scaling Settings:

4. Set Page Orientation

• Still in the Page Setup dialog, choose Portrait or Landscape.
• Landscape is usually better for wide spreadsheets with many columns.
• Portrait is better for longer spreadsheets with fewer columns.

5. Preview Before Printing

• Press Ctrl + P (Windows) or Command + P (Mac) to open the Print Preview.
• Check if your data is readable.
  If the text looks too small:
  • Hide unnecessary rows or columns.
  • Reduce font size slightly.
  • Adjust margins for more space.

6. Print

• When you’re happy with the preview, select your printer and click Print.
• Your entire Excel sheet will be printed on one page.

Quick Method: Fit to One Page from Print Preview

If you don’t want to open the Page Setup window, you can quickly scale your Excel sheet from the print screen.

1. Go to File > Print.
2. Find the Scaling option (it might be labeled “No Scaling” by default).
3. Click the dropdown and select Fit Sheet on One Page.
4. The preview updates instantly.
5. Click Print when ready.

Tips for Better Printing Results

Even though scaling is easy, sometimes your sheet becomes too small to read when forced onto one page. Here’s how to avoid that:

Hide Unnecessary Data

• Remove blank columns or rows.
• Hide columns with supporting details not needed in the printout.

Adjust Column Widths

• Select your entire sheet and double-click column boundaries to auto-fit content.
• This reduces wasted space and makes text more compact.

Change Margins

• Go to Page Layout > Margins.
• Select Narrow or Custom Margins to get more room.

Reduce Font Size

• Slightly lowering your font from 11pt to 9pt can make a big difference without hurting readability.

Print Only the Selection

• Highlight the range you want to print.
• Go to File > Print and select Print Selection in the settings.

Printing Only Columns or Rows on One Page

Sometimes you don’t need everything on one sheet—only the columns or rows.

• Fit All Columns on One Page – Keeps all columns together but allows rows to span multiple pages.
• Fit All Rows on One Page – Keeps all rows together but allows columns to span multiple pages.

You can select these options from the Scaling dropdown in the print settings.

How Scaling Works in Excel

Scaling in Excel works by resizing the worksheet to fit a specific number of pages without changing your actual data. Excel compresses or expands the content proportionally so it fits within the printable area.

• Fit to Width – Shrinks horizontally to fit the page width.
• Fit to Height – Shrinks vertically to fit the page height.
• Fit to Page – Shrinks in both directions to fit exactly on one page.

Common Issues When Printing on One Page

Text Too Small

If your worksheet has a lot of data, scaling to one page might make it hard to read.
Solution: Hide unused data or print a selection.

Page Breaks in the Wrong Place

Sometimes Excel still breaks pages awkwardly.
Solution: Use Page Break Preview under the View tab to manually adjust page breaks.

Margins Cut Off

If parts of your sheet get cut off:

• Set margins to “Normal” or “Narrow”.
• Check printer paper size (A4, Letter, etc.).

Best Practices for Professional Printouts

• Use clear headings for columns and rows.
• Add gridlines for easier reading (Page Layout > Sheet Options > Gridlines).
• Include header and footer information like titles, dates, and page numbers.
• Always preview before printing to avoid wasted paper.

Printing on One Page in Excel for Mac

The steps on Excel for Mac are almost the same:

1. Go to Layout (instead of Page Layout).
2. Click Page Setup.
3. Under Scale to Fit, enter 1 page wide and 1 page tall.
4. Set orientation, margins, and preview.

Final Thoughts

Printing an Excel spreadsheet on one page is simple once you know how to use the Page Setup and Scaling features. Whether you use the full setup dialog or the quick print preview method, you can make your data look clean, professional, and easy to read.

Remember, scaling is powerful, but too much data on one page can reduce clarity, so balance readability with page efficiency.

FAQs

Vaishvi Desai

Vaishvi Desai is the founder of Excelsamurai and a passionate Excel enthusiast with years of experience in data analysis and spreadsheet management. With a mission to help others harness the power of Excel, Vaishvi shares her expertise through concise, easy-to-follow tutorials on shortcuts, formulas, Pivot Tables, and VBA.