Excel - Print worksheets and workbooks Tutorial

In this video, you will learn how to print worksheets and workbooks in Microsoft Excel.
The video covers the steps to print the worksheet you are working on, as well as the entire workbook.
It demonstrates how to access the print preview, view different pages, and select the desired print options.
This knowledge will help you efficiently print your Excel documents and optimize your workflow.

1:07
4141 views

Available in Microsoft365

Objectifs :

This document aims to provide a comprehensive guide on how to print worksheets and workbooks in Excel, detailing the steps and options available for effective printing.

Chapitres :

Introduction to Printing in Excel
Printing worksheets in Excel is a straightforward process that allows users to create physical copies of their work. This guide will walk you through the steps to print a single worksheet or an entire workbook, ensuring you understand the available options and settings.
Printing a Single Worksheet
To print the worksheet you are currently working on, follow these steps: 1. Click on the 'File' menu in the top left corner of the Excel window. 2. Select 'Print' from the dropdown menu. 3. A print preview will appear, showing you how the printed worksheet will look. 4. At the bottom of the preview, Excel indicates the number of pages that will be printed. For example, it may show '2 pages' in this instance. 5. Click the 'Print' button to proceed with printing the worksheet.
Printing the Entire Workbook
If you wish to print the entire workbook instead of just the active sheet, follow these steps: 1. Before clicking 'Print', go to the 'Settings' section in the print menu. 2. Click the arrow next to 'Print Active Sheets' to reveal more options. 3. Select 'Print Entire Workbook'. 4. The print preview will now display the first page of the first worksheet, and Excel will inform you of the total number of pages to be printed. For instance, it might indicate '28 pages'. 5. Use the 'Next Page' arrow to navigate through the different pages in the preview. 6. Once you are ready, click 'Print' to print the entire workbook.
Exploring More Print Options
Excel offers various print options to customize your printing experience. You can adjust settings such as: - Page orientation (portrait or landscape) - Margins - Scaling options to fit the content on the page - Print titles and headers for better organization These options can be accessed in the print settings menu, allowing you to tailor the printout to your specific needs.
Conclusion
Understanding how to print worksheets and workbooks in Excel is essential for effective document management. By following the steps outlined in this guide, you can ensure that your printed materials are clear, organized, and meet your requirements. Remember to explore the various print options available to enhance your printing experience.

FAQ :

How do I print a worksheet in Excel?

To print a worksheet in Excel, click on 'File', then select 'Print'. You will see a preview of the printed worksheet and can choose to print it from there.

What is Print Preview in Excel?

Print Preview is a feature that shows you how your document will look when printed. It allows you to check the layout and make adjustments before printing.

Can I print multiple sheets at once in Excel?

Yes, to print multiple sheets, select 'Print' under 'File', then click the arrow next to 'Print Active Sheets' in the Settings section to choose the sheets you want to print.

What does it mean when Excel says it will print multiple pages?

When Excel indicates it will print multiple pages, it means that the content of your worksheet spans more than one page. You can navigate through the pages in Print Preview.

How can I adjust print settings in Excel?

You can adjust print settings by clicking on 'File', then 'Print', and using the options available in the Settings section to customize your print job.

Quelques cas d'usages :

Printing Reports for Meetings

Professionals can use the print feature in Excel to print reports or data summaries for meetings. By using Print Preview, they can ensure the layout is clear and easy to read, enhancing communication during presentations.

Creating Handouts for Training Sessions

Trainers can print worksheets containing key information or exercises for participants. By selecting the appropriate print settings, they can print only the necessary sheets, saving paper and ensuring focused content.

Generating Invoices

Businesses can create and print invoices directly from Excel. By using the print function, they can ensure that all necessary details are included and formatted correctly for professional presentation.

Printing Financial Statements

Accountants can print financial statements for clients or stakeholders. Utilizing Print Preview allows them to verify that all data is displayed correctly across multiple pages before finalizing the print job.

Preparing Educational Materials

Educators can print worksheets or study guides for students. By adjusting print settings, they can print specific sections or pages, making it easier to distribute relevant materials.

Glossaire :

Print

The process of producing a physical copy of a document or worksheet from a computer.

Worksheet

A single page or sheet in an Excel workbook where data is organized in rows and columns.

Workbook

A file in Excel that contains one or more worksheets.

Print Preview

A feature in Excel that allows users to see how a document will look when printed before actually printing it.

Active Sheets

The currently selected worksheet(s) in an Excel workbook that will be printed.

Settings

Options in Excel that allow users to customize how documents are printed, including selecting which sheets to print.

00:00:07

click File; Print.

00:00:12

You'll see a preview of what the printed worksheet will look like.

00:00:17

Down here, Excel tells you how many pages it is;

00:00:21

two in this example;

00:00:24

and click Print.

00:00:27

To print the entire workbook, before you click Print,

00:00:31

under Settings, click the arrow next to Print active sheets;

00:00:36

click Print entire workbook;

00:00:40

Print preview now shows you the first page of the first worksheet.

00:00:45

Excel now tells you it'll print 28 pages.

00:00:51

Click the Next page arrow to view different pages,

00:00:58

and click Print.

00:01:02

Up next: more print options.

Mandarine AI: WHAT YOU SHOULD KNOW

RELATED COURSES This tutorial is part of the following courses

2796 Views

Video Training Microsoft Excel - Discovery level

Discover and familiarize yourself with Excel: from creating and using your tables to enhancing your visuals and collaboration. Our introduct...

ALL COURSES