How to Print an Entire Workbook in Microsoft Excel for Office 365

The steps in this article will show you how to change a print setting in your Excel file so that you can quickly print the entire workbook. We cover the steps briefly at the top of this article, then continue below with more information and pictures of the steps.

  1. Open your file in Excel.
  2. Click the File tab.
  3. Click the Print tab.
  4. Click the Print Active Sheets button, then choose the Print Entire Workbook option.

While many people that create spreadsheets in Microsoft Excel will only use one of the tabs in their workbook, you are able to create multiple worksheet tabs in one workbook.

If you find yourself in a situation where you need to print all of the worksheets in your workbook, the prospect of switching between individual worksheet tabs and printing them individually could be a little daunting. Fortunately there is an option on the Print menu that lets you print the entire workbook at once.

How to Print the Entire Workbook in Microsoft Excel

The steps in this article were performed in Microsoft Excel for Office 365.

Step 1: Open your workbook in Excel.

Step 2: Select the File tab at the top-left corner of the window.

click the File tab

Step 3: Choose the Print tab at the left side of the window.

select the Print tab

Step 4: Click the Print Active Sheets button, then select the Print Entire Workbook option.

how to print the entire workbook in Excel

You can then click the Print button to print all of the worksheets in your workbook.

Is your printed spreadsheet difficult to understand because you can’t see headings on the pages after the first one? Find out how to repeat the first row at the top of every page in Excel and make subsequent pages of your printed file easier to read.