✦Template Printable Ideas Insights

Print All Excel Sheets: Mastering Workbook

By

Have you wondered how to accomplish a specific task across multiple sheets in an Excel workbook? Excel is a robust tool that allows you to manage and manipulate data effectively. One common task is printing all sheets within a workbook. Here, we will guide you through the process of printing multiple sheets in an Excel workbook.

Before you begin, it's crucial to understand that Excel will print each sheet starting from the left side of the document. If your sheets are not aligned vertically, you may want to adjust their arrangement before proceeding. Now, let's dive into the step-by-step process to print all sheets in an Excel workbook.

Preparing Your Workbook

Before printing, it's essential to ensure your sheets are well-prepared and ready for print. Here, we discuss two key preparation aspects: checking the layout and setting print areas.

Excel Formula Cheat Sheet Printable - Excel Functions Guide PDF - Excel Reference Sheet Digital Download
Excel Formula Cheat Sheet Printable - Excel Functions Guide PDF - Excel Reference Sheet Digital Download
[FREE] 141 Free Excel Templates and Spreadsheets
[FREE] 141 Free Excel Templates and Spreadsheets
How to create a list of all worksheet names from a workbook?
How to create a list of all worksheet names from a workbook?

First, ensure your data is neatly organized and fits well within the visible area. You can adjust column widths and cell content to make the data presentable and printable.

Checking the Layout

Get an overview of your workbook by clicking on the "Sheet1" or "Sheet2" tabs at the bottom, and observe the layout of each sheet. This will help you notice any misalignment, large areas of white space, or excessive data that might cause printing issues.

how to print large excel sheet in one page
how to print large excel sheet in one page
Free Monthly Budget Excel Spreadsheet
Free Monthly Budget Excel Spreadsheet
Workbook in Excel
Workbook in Excel

If you find sheets that need adjustment, align the data using AutoFit columns or by manually adjusting column widths. To AutoFit columns, select the column and click on the fit-to-size icon (AutoFit Columns Icon) in the 'Home' tab.

Setting Print Areas

Print areas allow you to specify a range of cells on a sheet to be printed. This is useful when you only want specific data to print, which can help save paper. To set a print area:

  • Select the range of cells you want to print.
  • Go to the 'Page Layout' tab.
  • Click 'Print Area' in the 'Page Setup' group, then select 'Set Print Area'.

Now, let's move on to printing all your workbook's sheets.

How to Create a Workbook in Excel?
How to Create a Workbook in Excel?
Excel - Link Data Between Worksheets In A Workbook In Excel
Excel - Link Data Between Worksheets In A Workbook In Excel
How To Print Large Excel Sheet | One Page Print Setup (Excel Tips & Tricks)
How To Print Large Excel Sheet | One Page Print Setup (Excel Tips & Tricks)
Copy Data From One Sheet to Another in Excel
Copy Data From One Sheet to Another in Excel
Simple Excel Practice Exercise for Beginners
Simple Excel Practice Exercise for Beginners
an image of a spreadsheet with graphs and pie chart on the top right side
an image of a spreadsheet with graphs and pie chart on the top right side

Printing All Sheets in an Excel Workbook

Having prepared your workbook, you're ready to print all sheets in a few simple steps.

Printing all sheets simultaneously is not a default feature in Excel; however, you can achieve this by tweaking some settings and initiating the print command with a macro.

Printing Sheets Using a Macro

To print all sheets within your workbook, you'll need to use a macro script. Don't worry; you won't have to code anything – you can use a pre-existing script or 'template' to get the job done. Follow these steps:

Your Custom Budget Spreadsheet Solution
Your Custom Budget Spreadsheet Solution
Top Excel Formulas Cheat Sheet for Students
Top Excel Formulas Cheat Sheet for Students
7 Excel Printing Tips: How to Print Your Spreadsheet Step-by-Step
7 Excel Printing Tips: How to Print Your Spreadsheet Step-by-Step
  1. Open your workbook.
  2. Press Alt + F11 to open the Visual Basic for Applications (VBA) window.
  3. VBA window appears, press Insert on the Menu bar, then select 'Module' to create a new module.
  4. Paste the following macro into the new module:
      Sub PrintAllSheets()
      Dim ws As Worksheet
    
      For Each ws In ActiveWorkbook.Worksheets
      ws.PrintOut
      Next ws
      End Sub
      
  5. Save and close the VBA window.
  6. Return to your workbook, then press Alt + F8 to open the Macro dialog box.
  7. Select 'PrintAllSheets' in the list and click 'Run'.
  8. The workbook's print dialog box appears; make any necessary adjustments to scale, paper settings, etc., then click 'Print'.

All sheets within your workbook should print in the order you've arranged them.

Printing Sheets Manually

If you prefer a manual approach, you can print each sheet individually. Use the following steps:

  1. Open your workbook.
  2. Click the 'File' tab, then choose 'Print' from the left-hand menu.
  3. In the 'Printer' section, ensure the correct printer is selected.
  4. Select 'Print Active Sheets' in the 'Printer section'.
  5. Adjust scaling, paper size, orientation, and other print settings as required.
  6. Click the 'Print' button to initiate the print job.
  7. Repeat the above steps for each sheet in your workbook until you've printed all of them.

Now, all the sheets from your Excel workbook should be printed. You've successfully mastered the art of printing multiple sheets in an Excel workbook!