5 Ways to Print 2 Sheets on One Page in Excel

Printing large spreadsheets can often result in an overwhelming number of pages, especially when your data spans multiple sheets. One efficient way to manage this is by printing two or more sheets onto a single page. Here are five methods to achieve this in Microsoft Excel:

Using Page Layout Options

Excel’s Page Layout view provides several options to adjust how your sheets will print. Here’s how you can use it to print two sheets on one page:

• Open Excel and go to the File tab.
• Select Print, and then choose Page Layout.
• In the Page Setup dialog box, under the Page tab, click on the Options button.
• From the options, select 2 Pages per sheet under the Multiple pages drop-down menu.
• Press OK to apply changes and then print your document as usual.

📝 Note: This method does not scale down the sheets, meaning the text might be too small to read if the sheets are large.

Excel’s ‘Fit Sheet on One Page’ Feature

This feature allows you to fit all content from a single sheet onto one page, but we can use this to print two sheets:

• Select both sheets by holding Ctrl and clicking on their tabs.
• Navigate to Page Layout > Page Setup dialog box launcher.
• Under the Page tab, check Fit to:, select 1 page wide by 1 page tall.
• Click OK and then print.

Combining Sheets via VBA

If you’re comfortable with Excel VBA, you can automate the process of printing multiple sheets on one page:

Sub PrintTwoSheetsOnOnePage()
    Dim ws1 As Worksheet
    Dim ws2 As Worksheet
    Dim cmbWs As Worksheet

' Set references to your sheets
Set ws1 = ThisWorkbook.Worksheets("Sheet1")
Set ws2 = ThisWorkbook.Worksheets("Sheet2")

' Create a new worksheet
Set cmbWs = ThisWorkbook.Worksheets.Add

' Copy contents from Sheet1 and Sheet2 to the new combined sheet
ws1.UsedRange.Copy cmbWs.Range("A1")
ws2.UsedRange.Copy cmbWs.Range("A" & cmbWs.Rows.Count + 1)

' Adjust printing settings for the new sheet
With cmbWs.PageSetup
    .PrintArea = cmbWs.UsedRange.Address
    .FitToPagesWide = 1
    .FitToPagesTall = 1
End With

cmbWs.PrintOut
cmbWs.Delete


End Sub

🛠️ Note: This script creates a temporary sheet to combine and print the data from two sheets. Be cautious as it might delete data if not used correctly.

Using PDF Printers

Another approach involves using PDF printers:

• Install a virtual PDF printer on your computer (e.g., Adobe PDF, CutePDF).
• Go to File > Print, and select your PDF printer from the list.
• Print each sheet separately, saving the PDFs.
• Use a PDF editor to combine the two PDFs into one and then print the resulting document.

Manual Layout Adjustment

For those who prefer manual control over their print layout:

• Go to Page Layout > Print Titles to set print titles, ensuring your headers and titles are visible across pages.
• Adjust page breaks by dragging the blue lines in Page Break Preview mode.
• Check the Print Preview to ensure that both sheets fit on one page.

In summarizing these methods, it’s evident that Excel provides various ways to print multiple sheets onto a single page. Whether you choose the straightforward route through Page Layout options, utilize Excel’s built-in features like fitting to one page, automate with VBA, leverage PDF printers, or manually adjust layouts, each method offers unique advantages depending on your specific needs and technical comfort level. By mastering these techniques, you can save paper, time, and effort when printing extensive Excel documents, making your data management more efficient and eco-friendly.

Can I print more than two sheets on one page?

+

Yes, you can print more than two sheets by selecting additional sheets and using the ‘Fit Sheet on One Page’ feature or by adjusting the scale in Page Setup.

How do I ensure all data fits when printing multiple sheets?

+

You can use Excel’s Page Layout options or VBA to adjust scaling and ensure all content fits onto one page.

Will using PDF printers affect the quality of my printouts?

+

No, PDF printers create high-quality documents, but ensure your PDF settings are set for high resolution printing.

Is there a way to save time when frequently printing multiple sheets?

+

Using VBA to automate the printing process can significantly reduce the time spent on manual adjustments.

What should I do if my sheets contain complex graphs or images?

+

Adjust the scale and print layout settings to ensure these elements are visible, or print them separately if necessary.