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
- 4596 views
-
Excel - 3D Maps
- 1:41
- Viewed 6978 times
-
Excel - Cell references
- 1:34
- Viewed 4926 times
-
Excel - Copying formulas
- 3:00
- Viewed 4635 times
-
Excel - A closer look at the ribbon
- 3:55
- Viewed 5701 times
-
Excel - Start using Excel
- 4:22
- Viewed 5124 times
-
Excel - Advanced formulas and references
- 4:06
- Viewed 5028 times
-
Excel - Save and print an Excel workbook
- 1:53
- Viewed 4211 times
-
Excel - Insert columns and rows
- 4:16
- Viewed 4670 times
-
Remove a watermark
- 2:20
- Viewed 43074 times
-
Change the default font for your emails
- 1:09
- Viewed 28569 times
-
Collapsible headings
- 3:03
- Viewed 22576 times
-
How to recall or replace a sent email in Outlook Web
- 0:53
- Viewed 21724 times
-
Activate the features of Teams Premium
- 3:48
- Viewed 20541 times
-
How do I prevent the transfer of an email?
- 2:07
- Viewed 19064 times
-
Create automatic reminders
- 4:10
- Viewed 13674 times
-
Protect a document shared by password
- 1:41
- Viewed 12427 times
-
Add a sound effect to a transition
- 3:45
- Viewed 11882 times
-
Morph transition
- 0:43
- Viewed 11719 times
-
Remove a watermark
- 2:20
- Viewed 43074 times
-
Change the default font for your emails
- 1:09
- Viewed 28569 times
-
Collapsible headings
- 3:03
- Viewed 22576 times
-
How to recall or replace a sent email in Outlook Web
- 0:53
- Viewed 21724 times
-
Activate the features of Teams Premium
- 3:48
- Viewed 20541 times
-
How do I prevent the transfer of an email?
- 2:07
- Viewed 19064 times
-
Create automatic reminders
- 4:10
- Viewed 13674 times
-
Protect a document shared by password
- 1:41
- Viewed 12427 times
-
Add a sound effect to a transition
- 3:45
- Viewed 11882 times
-
Morph transition
- 0:43
- Viewed 11719 times
-
Use Facilitator notes after a meeting
- 02:53
- Viewed 6 times
-
Enable Facilitator during a Teams meeting
- 02:04
- Viewed 11 times
-
Enable Facilitator before a Teams meeting
- 02:16
- Viewed 8 times
-
Prerequisites and limitations of Facilitator
- 01:55
- Viewed 7 times
-
Required licenses for using Facilitator in Teams
- 02:09
- Viewed 12 times
-
Understand Facilitator in Teams
- 02:14
- Viewed 7 times
-
Configure a child agent
- 03:52
- Viewed 50 times
-
Enhance the assistant with tools
- 02:42
- Viewed 14 times
-
Can you request the deletion of your data ?
- 01:40
- Viewed 68 times
-
GPDR : 4 simple reflexes
- 05:07
- Viewed 77 times
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 :
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.