5 Ways to Print 2 Excel Sheets on 1 Page

Printing multiple Excel sheets on a single page can significantly save paper and streamline your document management, whether you're compiling financial reports, gathering project data, or preparing for a presentation. Here are five effective strategies to help you print two Excel sheets onto one page with ease.

1. Adjusting Page Layout Settings

One of the simplest ways to fit two sheets on one page is by altering the page setup:

• Open the Excel workbook with the sheets you want to print.
• Go to the ‘File’ tab, then ‘Print’, or use the shortcut Ctrl + P.
• In the ‘Settings’ section, choose ‘Print Entire Workbook’ to print all sheets or select specific sheets you wish to include.
• Under the ‘Scaling’ options, select ‘Fit Sheet on One Page’ or manually adjust the scale percentage.

📝 Note: Ensure both sheets have similar page orientations to avoid confusion during printing.

2. Using Print Area

By setting a print area, you can control what part of the sheets gets printed:

• Select the ranges on both sheets that you want to print. You can hold Ctrl to select non-adjacent cells.
• Go to Page Layout tab, click on Print Area, then Set Print Area.
• Adjust the scaling in the print preview to fit these areas onto one page.

3. Creating a Collated Print Layout

If your printer supports double-sided printing or you’re looking to emulate this with paper collation:

• Print one sheet on the front and the second on the back of the same page using printer settings. If your printer doesn’t support duplex printing, manually turn the paper over and print the second sheet.
• For single-sided printing, print one sheet, then realign the paper for the second sheet to simulate a booklet or collated layout.

📋 Note: For professional documents, ensure print quality settings are high to avoid any readability issues.

4. Manually Creating a Layout

This method gives you the most control over how the information is displayed:

• Create a new sheet in your workbook and copy-paste data from the sheets you want to print.
• Adjust the layout by resizing cells, columns, or rows manually or through Excel’s Format as Table options.
• Preview and print this new sheet, which now contains data from both sheets in the desired layout.

5. Using Macros for Automated Layout

For those comfortable with Excel macros, you can automate the process:

• Create a VBA macro to combine the data from two sheets and format it to fit onto one page.
• Here’s a basic example of how you might start the macro code:

Sub CombineAndPrint()
    Dim ws1 As Worksheet, ws2 As Worksheet, ws3 As Worksheet
    Set ws1 = Sheets(“Sheet1”)
    Set ws2 = Sheets(“Sheet2”)
    Set ws3 = Sheets.Add

With ws1.UsedRange
    .Copy
    ws3.Range("A1").PasteSpecial xlPasteValues
End With
With ws2.UsedRange
    .Copy
    ws3.Range("B1").PasteSpecial xlPasteValues
End With

' Adjust sheet formatting here

ws3.PrintPreview


End Sub

🤓 Note: Macros require enabling developer mode in Excel and can be complicated for beginners. Use them with caution.

To wrap up, whether you need to print two Excel sheets on one page for convenience or space-saving, these methods provide flexibility and control over your printing process. Each approach has its advantages, from quick scaling to detailed formatting, allowing you to choose what best fits your needs.

Can I print multiple Excel sheets on one page without adjusting scaling?

+

While adjusting scaling is a straightforward method, you can also manually resize cells or use macros to fit content without changing scale settings. However, these alternatives might require more setup time.

How can I ensure the text remains legible when fitting sheets onto one page?

+

Choose a reasonable scale percentage or font size. Preview your print layout to make sure all details are readable. If the text becomes too small, consider adjusting the content or using landscape orientation for more space.

What if I have more than two sheets to print on one page?

+

For more than two sheets, consider using methods like manually creating a layout or using a macro to combine data. You’ll need to ensure the combined data fits on one page or adjust scaling accordingly.

Will these methods work with any printer?

+

Yes, these methods should work with most printers. However, the functionality for duplex printing might depend on your printer model. For collated printing, you might need to manually align paper.

Can macros be used for large-scale printing tasks?

+

Yes, macros can automate the process for large-scale printing tasks, making it much more efficient to manage multiple sheets, especially if you’re dealing with regular reports or data aggregation.