✦Template Printable Ideas Insights

Print Excel Workbook: Step-by-Step Guide

By

Printing a workbook in Excel is a straightforward process that enables you to create a hard copy of your digital data. Whether you're printing worksheets, charts, or the entire workbook, Excel offers several customization options to suit your needs. Let's delve into the steps involved in printing an Excel workbook.

Before we proceed, ensure your printer is connected and fully functional. Also, check if you have sufficient ink or toner and paper to avoid interruptions during the printing process.

Preparing Your Workbook for Printing

Before initiating the print command, it's crucial to prepare your workbook to ensure it prints accurately and efficiently.

Workbook in Excel
Workbook in Excel
[FREE] 141 Free Excel Templates and Spreadsheets
[FREE] 141 Free Excel Templates and Spreadsheets
How to Create a Workbook in Excel?
How to Create a Workbook in Excel?

1. **Select the Worksheets to Print**: By default, Excel prints all worksheets in a workbook. However, if you want to print specific sheets, select them before proceeding to the print dialog box. To do this, click on the sheet tab at the bottom of the window to select the worksheets you want to print.

Adjusting Print Settings

To initiate the print process, click on the 'File' tab in the Excel ribbon, then select 'Print'. In the print dialog box, you'll find various print settings that allow you to customize your print job.

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
How to create a list of all worksheet names from a workbook?
How to create a list of all worksheet names from a workbook?
Free Monthly Budget Excel Spreadsheet
Free Monthly Budget Excel Spreadsheet

2. **Choose the Printer**: Excel automatically selects the default printer connected to your computer. However, if you want to print to a different printer, click on the 'Printer' drop-down list and select your preferred printer.

Setting Print Ranges

Excel allows you to print specific ranges within your worksheets instead of printing the entire sheet. This feature is particularly useful when you want to print only a subset of data.

3. **Select a Print Area**: To print a specific range, click on the 'Selection' option in the print dialog box and choose the range you want to print. Alternatively, you can manually select the range in the worksheet, and Excel will print that selection.

a laptop computer sitting on top of a desk next to a mouse and keyboard with the words microsoft excel free for beginners
a laptop computer sitting on top of a desk next to a mouse and keyboard with the words microsoft excel free for beginners
User level security in Excel Workbook for different worksheets
User level security in Excel Workbook for different worksheets
Bookkeeping Spreadsheets, The 5 Best Websites to Download Free Excel Templates 💵
Bookkeeping Spreadsheets, The 5 Best Websites to Download Free Excel Templates 💵
138K views | Reel by Miss Excel
138K views | Reel by Miss Excel
Harness the Awesomeness of Excel Power Query on Multiple Workbooks
Harness the Awesomeness of Excel Power Query on Multiple Workbooks
7 Excel Printing Tips: How to Print Your Spreadsheet Step-by-Step
7 Excel Printing Tips: How to Print Your Spreadsheet Step-by-Step

Printing Specific Parts of Your Workbook

In some cases, you may want to print only charts, graphs, or other non-data elements in your workbook. Excel provides several options to print these elements.

4. **Print Active Sheets**: If you want to print only the active sheets, click on the 'Active Sheets' option in the print dialog box. This will print only the sheets currently in view.

Printing Charts and Graphs

To print a chart or graph, click on it to select it, then proceed to the print dialog box. Excel will automaticallyprint only the selected chart.

a notebook with microsoft excel written on it
a notebook with microsoft excel written on it
Executive Function Workbook Excel Spreadsheet | Daily Focus Planner, Weekly Plan, Priority Matrix, Time Blocks, Decision Log & Meeting Prep
Executive Function Workbook Excel Spreadsheet | Daily Focus Planner, Weekly Plan, Priority Matrix, Time Blocks, Decision Log & Meeting Prep
How to Save Entire Workbook As PDF From Excel
How to Save Entire Workbook As PDF From Excel

5. **Print Pictures**: Similarly, you can print individual pictures in your Excel workbook. Select the picture you want to print, then proceed to the print dialog box. Excel will print only the selected picture.

Printing Multiple Copies or Pages per Sheet

Sometimes, you may need to print multiple copies of a worksheet or fit multiple pages of data onto a single sheet.

6. **Print Multiple Copies**: To print multiple copies of a worksheet, enter the required number in the 'Copies' field in the print dialog box.

7. **Fit to Pages**: To fit multiple pages of data onto one sheet, click on the 'Printing Options' button, then select 'Fit to pages wide by pages tall'. Enter the desired number of pages in the width and height fields, then click 'OK'.

Reviewing and Printing Your Workbook

Before finalizing your print job, it's essential to preview your print output and make any necessary adjustments.

8. **Preview Print Output**: Click on the 'Print Preview' button in the Excel ribbon or press 'Ctrl + F2' to view how your print job will look. Use the zoom and fit options to adjust the view, and the 'Sorted' and 'Filtered' options to ensure you're printing the correct data.

Finalizing Your Print Job

Once you're satisfied with your print settings and preview, you can finalize your print job.

9. **Initiate the Print Job**: Click on the 'Print' button in the print dialog box. Excel will send your print job to the selected printer, and the printer will start printing your workbook.

Post-printing, ensure that your hard copy aligns with your expectations. If needed, adjust your print settings and retry. With these steps, you should be well-equipped to print an Excel workbook efficiently and accurately.