Excel Tutorial: How To Print Multiple Pages On One Page Excel


Are you tired of wasting paper and ink by printing out individual pages from your Excel spreadsheet? In this Excel tutorial, we will show you how to print multiple pages on one page in Excel, allowing you to condense your document and save resources. This handy feature is often overlooked, but once mastered, it can significantly improve efficiency and reduce waste.

Key Takeaways

  • Printing multiple pages on one page in Excel can help save paper and ink.
  • Access the Page Layout options to set up printing preferences.
  • Use the Print Preview function to ensure the layout is correct before printing.
  • Customize headers and footers for printed pages to add important information.
  • Mastering advanced printing options can improve efficiency and reduce waste.

Understanding Page Layout in Excel

When working with Excel, it is important to understand how to customize the page layout in order to efficiently print and present your data. The page layout options in Excel allow you to control how your data is displayed and printed on paper.

A. How to access the Page Layout options

Accessing the Page Layout options in Excel is simple and can be done by following these steps:

  • Click on the "Page Layout" tab in the Excel ribbon at the top of the window.
  • Once on the Page Layout tab, you will see various options for customizing the layout and appearance of your data for printing.

B. Explanation of the different settings for page layout

Excel offers several settings for customizing the page layout, including:

  • Page Orientation: This setting allows you to choose between portrait and landscape orientation for your printed pages. Portrait orientation is typically used for documents that are taller than they are wide, while landscape orientation is used for wider documents.
  • Page Size: Excel allows you to select from a variety of standard page sizes, such as letter, legal, or A4. You can also set a custom page size if needed.
  • Margins: You can adjust the margins of the printed page to control the amount of white space around the edges of the paper. This can be useful for fitting more content onto a single page.
  • Scale: The scale setting allows you to adjust the size of the printed content to fit on the page. You can choose to fit the content to a specific number of pages, or adjust the scaling percentage to make the content larger or smaller.
  • Print Area: Excel also allows you to specify a print area, which is the range of cells that will be printed. This can be useful for printing a specific section of a larger worksheet.

Setting up Print Options

When it comes to printing multiple pages on one page in Excel, it’s important to set up the print options to ensure the desired layout and formatting. Here are the key steps to follow:

A. Choosing the number of pages per sheet
  • Click on the File tab and select Print.
  • Under the Settings section, choose the number of pages you want to print per sheet from the Pages Per Sheet dropdown menu.
  • Options include printing 1, 2, 4, 6, 9, or 16 pages per sheet, depending on your specific requirements.

B. Adjusting margins and orientation for printing
  • After selecting the number of pages per sheet, you may need to adjust the margins and orientation to ensure the content fits properly.
  • Click on the Margins dropdown menu and select a suitable margin option, such as Narrow or Custom Margins.
  • Additionally, you can set the Orientation to Landscape if it better suits the layout of your content.

Previewing the Document

Before printing multiple pages on one page in Excel, it's important to preview the document to ensure the layout is correct. This will help avoid wasting paper and ensure that the printed document looks the way you intended.

A. Using the Print Preview function to ensure the layout is correct

Open the Excel document you want to print and go to the "File" tab. Click on "Print" to access the print settings. Then, select "Print Preview" to see how the document will look when printed.

B. Making any necessary adjustments before printing

While in the Print Preview mode, you can make adjustments to the layout, such as changing the margins, adjusting the size of the content, or selecting the number of pages you want to print on one page. This will ensure that the document is formatted correctly before printing.

Printing the Document

Printing a document in Excel is a simple process, but there are a few key steps to keep in mind to ensure that your document comes out exactly as you intend. This tutorial will guide you through the process of printing multiple pages on one page in Excel.

A. Selecting the printer and number of copies

Before you print your document, it is important to select the correct printer and set the number of copies that you want to print. Here's how to do it:

  • Click on the "File" tab in the Excel ribbon.
  • Click on "Print" in the left-hand menu.
  • From the "Printer" dropdown menu, select the printer that you want to use.
  • In the "Copies" section, enter the number of copies that you want to print.

B. Tips for troubleshooting common printing issues

Despite the straightforward nature of printing in Excel, there are some common issues that users may encounter. Here are some tips for troubleshooting these issues:

1. Blank pages

  • Check the print area: If you are only seeing blank pages when you print, it's possible that the print area is not set correctly. Go to the "Page Layout" tab and click on "Print Area" to ensure that the correct range is selected.
  • Check for hidden rows or columns: Hidden rows or columns in your spreadsheet could be causing the blank pages. Unhide any hidden rows or columns before printing.

2. Print quality issues

  • Check printer settings: Make sure that your printer settings are configured for the best print quality. This can usually be adjusted in the printer preferences menu.
  • Check ink or toner levels: If you are experiencing print quality issues such as faded text or streaks, it may be time to replace your ink or toner cartridges.

By keeping these tips in mind, you can ensure that your Excel document prints correctly and without any issues.

Advanced Printing Options

When it comes to printing in Excel, there are several advanced options that can make the process more efficient and customized to your specific needs. In this tutorial, we will explore some of the additional printing settings that Excel offers, as well as how to customize headers and footers for printed pages.

Exploring additional printing settings in Excel

  • Print Selection: If you only want to print a specific area of your spreadsheet, you can use the Print Selection option to select the cells or range of cells that you want to print.
  • Page Setup: The Page Setup dialog box allows you to customize the layout, orientation, and margins of your printed page. You can also adjust the scaling and paper size to fit your content onto the page.
  • Print Preview: Before sending your spreadsheet to the printer, it's a good idea to use the Print Preview feature to see how the printed pages will look. This can help you catch any formatting issues before wasting paper and ink.
  • Print Quality: Excel also offers options to adjust the print quality, which can be useful if you are printing high-resolution graphics or images.

How to customize headers and footers for printed pages

Customizing headers and footers can help you add important information to your printed pages, such as page numbers, the date, or the name of your spreadsheet. To customize the headers and footers in Excel, follow these steps:

  • Step 1 - Access Page Setup: Go to the Page Layout tab and click on the dialog box launcher in the Page Setup group to open the Page Setup dialog box.
  • Step 2 - Navigate to the Header/Footer tab: In the Page Setup dialog box, click on the Header/Footer tab to access the options for customizing headers and footers.
  • Step 3 - Customize the headers and footers: In this tab, you can add and format text, insert page numbers, and include built-in elements such as the file name or sheet name.
  • Step 4 - Apply the changes: Once you have customized the headers and footers to your liking, click OK to apply the changes to your spreadsheet.


Printing multiple pages on one page in Excel can greatly save paper and ink, while also providing a more concise and organized document. It is an important skill to have for anyone working with data and spreadsheets.

Before printing, always make sure to preview your document to ensure it looks as intended. Additionally, consider adjusting the scaling options to fit more content on each page without sacrificing readability.

By following these final tips, you can ensure successful printing in Excel and make the most out of your resources.

Excel Dashboard

ONLY $99

    Immediate Download

    MAC & PC Compatible

    Free Email Support

Related aticles