✦Template Printable Ideas Insights

Excel: Step-by-Step Guide to Printing Your Workbook

By

Ever found yourself in a situation where you need to print an Excel workbook, but aren't quite sure how to go about it? You're not alone. Microsoft Excel, a robust tool in the realm of spreadsheet software, offers several ways to print your workbooks. Let's delve into the details, ensuring you'll never struggle with this task again.

Before we dive in, let's remember that the method to print an Excel workbook depends on the version you're using. Here, we'll cover the most recent version, Excel 2019, but the process is similar in other versions like Excel 2016 and Excel 365.

Printing a Single Sheet

If you only need to print one sheet from your workbook, follow these steps:

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. Open your workbook and click on the sheet you wish to print. It will become active and highlighted in the bottom-left corner.

Changing Page Layout

Before printing, you might want to adjust your page layout to fit the entire sheet on one page. Here's how:

Your Custom Budget Spreadsheet Solution
Your Custom Budget Spreadsheet Solution
Free Monthly Budget Excel Spreadsheet
Free Monthly Budget Excel Spreadsheet
Simple Excel Practice Exercise for Beginners
Simple Excel Practice Exercise for Beginners

1. Go to the 'Page Layout' tab in the ribbon. Click on the small arrow at the bottom-right of the 'Scale to Fit' group.

2. Choose 'Fit to 1 page wide' and 'Fit to 1 page tall'. Adjust as necessary to ensure all your data fits on one page.

Setting Print Area

To print a specific area of your sheet, you can set a 'Print Area'. Here's how:

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
how to automatic open a specific workbook when you start excel - free microsoft ex
how to automatic open a specific workbook when you start excel - free microsoft ex
How to create a list of all worksheet names from a workbook?
How to create a list of all worksheet names from a workbook?
User level security in Excel Workbook for different worksheets
User level security in Excel Workbook for different worksheets
How to Duplicate a Worksheet in Excel
How to Duplicate a Worksheet in Excel
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. Select the cells you want to print. Go to the 'Page Layout' tab and click on 'Print Area' in the 'Page Setup' group.

2. Choose 'Set Print Area'. Your selected area will be ready to print.

Printing Multiple Sheets

If your workbook contains multiple sheets and you need to print them all, follow these steps:

How to separate information on Excel
How to separate information on Excel
138K views | Reel by Miss Excel
138K views | Reel by Miss Excel
a notebook with microsoft excel written on it
a notebook with microsoft excel written on it

1. Go to the 'File' tab, then select 'Print'. In the 'Settings' section, tick the 'Print Selection' box.

Printing Sheets in Booklet Form

Want to print your workbook in a booklet format? Here's how you can do it:

1. Select the sheets you want to print. Go to the 'Page Layout' tab and click on the small arrow in the 'Scale to Fit' group.

2. Choose 'Fit to 2 pages wide'. This will set up each sheet to print as a two-page spread, perfect for creating a booklet.

Printing Sheets in Landscape Orientation

If your data is wider than it is tall, you might want to rotate your sheets to print in landscape orientation. Here's how:

1. Go to the 'Page Layout' tab and click on the 'Orientation' icon in the 'Page Setup' group.

2. Choose 'Landscape'. Your active sheet will rotate, and other sheets in the workbook will follow suit.

There you have it – various methods to print an Excel workbook efficiently. Now that you're an expert, you can breeze through this task, leaving your colleagues impressed. Happy printing!