✦Template Printable Ideas Insights

Print All Sheets in Excel Workbook: Step-by-Step Guide

By

Printing all sheets in a workbook can be a breeze if you know the right techniques. Whether you're studying from a digital workbook, need to create hard copies for sharing, or simply want to record your notes, this guide walks you through the process. Let's dive in and explore how to print all sheets in a workbook efficiently.

Workbooks, especially those created in apps like Google Sheets or Microsoft Excel, can contain multiple sheets (or tabs), and printing only one sheet at a time can be time-consuming. Fear not! There are clever ways to print all sheets at once. Let's break down the process into simple, manageable steps.

Printing in Google Sheets

Google Sheets has an intuitive print feature that allows you to print all sheets in one go. Here's how:

How to create fillable PDF workbooks
How to create fillable PDF workbooks
DIY Toddler Busy Book Printable
DIY Toddler Busy Book Printable
Step By Step Print Guide For Printing Printables
Step By Step Print Guide For Printing Printables

First, ensure every sheet you want to print is visible. Click on the 'Sheets' button at the bottom-left corner, then select each sheet you'd like to include. Once all sheets are selected, proceed to the print function.

Printing All Sheets at Once

To print all selected sheets, click on 'File' in the menu, then select 'Print'. You'll notice a preview of all your selected sheets at the top. To the right of the preview, click on the 'Selected sheets' option. Now, choose your printer settings like paper size, orientation, and scale, then click on 'Print'.

Free Procreate Beginner’s Workbook
Free Procreate Beginner’s Workbook
Free Busy Binder Printables for Preschoolers
Free Busy Binder Printables for Preschoolers
Free Printable Worksheets for Kids | Math, Reading & More!
Free Printable Worksheets for Kids | Math, Reading & More!

Google Sheets will create a PDF file containing all selected sheets, which will then be sent to your printer.

Printing Each Sheet on Separate Pages

If you prefer each sheet to print on a new page, follow these steps:

Go to 'File', then 'Print'. Select the 'All' option instead of 'Selected sheets'. Now, set your printer settings, and click 'Print'. Each sheet will print on a separate page, with the sheet name displayed as a header.

How to Create a Fillable PDF Workbook
How to Create a Fillable PDF Workbook
a woman sitting at a desk with a laptop and pen in her hand, writing on the paper
a woman sitting at a desk with a laptop and pen in her hand, writing on the paper
Free ADHD Printables for Every Part of Life
Free ADHD Printables for Every Part of Life
Free Monthly Budget Excel Spreadsheet
Free Monthly Budget Excel Spreadsheet
List All Sheet Names In An Excel Workbook With & Without VBA
List All Sheet Names In An Excel Workbook With & Without VBA
🖨️ 11 Things To Print Out
🖨️ 11 Things To Print Out

Printing in Microsoft Excel

Microsoft Excel's print function also lets you print multiple sheets at once. Here's how to do it:

First, select the sheets you want to print by clicking on their respective sheet tabs. To select multiple adjacent sheets, click and drag over the sheet tabs. To select non-adjacent sheets, hold down 'Ctrl' (or 'Command' on a Mac) while clicking on the individual sheet tabs.

Printing Selected Sheets

Once you've selected your sheets, go to the 'File' menu, then select 'Print'. In the 'Print' tab, under 'Printer', make sure the correct printer is selected. Then, under the 'Print Range' section, choose the 'Selected sheets' option. Set your printer settings, and click 'Print'.

FREE Printable Activity and Coloring e-booklets
FREE Printable Activity and Coloring e-booklets
the workbook creator is displayed on top of a white background with many different pages
the workbook creator is displayed on top of a white background with many different pages
Self Development Workbook Sheet InDesign INDD
Self Development Workbook Sheet InDesign INDD
Free Printable Worksheet Generator | Custom Activity Book Maker
Free Printable Worksheet Generator | Custom Activity Book Maker

Your selected sheets will now be sent to your printer, with each sheet printing on a separate page.

Printing All Sheets with Headers

To print all sheets with a header that includes the sheet name, follow these steps:

In the 'Print' tab, under 'Print Range', choose the 'Sheets' option and then select 'All'. Now, go to the 'Settings' section, click on 'Sheet options', and select 'Print sheet names'. Set the rest of your printer settings, then click 'Print'.

Each sheet will now be printed on a separate page, with the sheet name displayed as a header.

And there you have it! No more struggling with printing individual sheets from your workbook. With these techniques, you can print all sheets quickly and efficiently. Happy printing!