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
- 4397 views
-
Excel - 3D Maps
- 1:41
- Viewed 6730 times
-
Excel - Cell references
- 1:34
- Viewed 4860 times
-
Excel - Copying formulas
- 3:00
- Viewed 4579 times
-
Excel - A closer look at the ribbon
- 3:55
- Viewed 5402 times
-
Excel - Save and print an Excel workbook
- 1:53
- Viewed 4161 times
-
Excel - Start using Excel
- 4:22
- Viewed 5055 times
-
Excel - Advanced formulas and references
- 4:06
- Viewed 4939 times
-
Excel - Insert columns and rows
- 4:16
- Viewed 4612 times
-
Remove a watermark
- 2:20
- Viewed 39989 times
-
Change the default font for your emails
- 1:09
- Viewed 23622 times
-
Collapsible headings
- 3:03
- Viewed 20301 times
-
How to recall or replace a sent email in Outlook Web
- 0:53
- Viewed 20259 times
-
Activate the features of Teams Premium
- 3:48
- Viewed 19713 times
-
How do I prevent the transfer of an email?
- 2:07
- Viewed 16966 times
-
Create automatic reminders
- 4:10
- Viewed 13136 times
-
Protect a document shared by password
- 1:41
- Viewed 12057 times
-
Morph transition
- 0:43
- Viewed 11231 times
-
Add a sound effect to a transition
- 3:45
- Viewed 10732 times
-
Remove a watermark
- 2:20
- Viewed 39989 times
-
Change the default font for your emails
- 1:09
- Viewed 23622 times
-
Collapsible headings
- 3:03
- Viewed 20301 times
-
How to recall or replace a sent email in Outlook Web
- 0:53
- Viewed 20259 times
-
Activate the features of Teams Premium
- 3:48
- Viewed 19713 times
-
How do I prevent the transfer of an email?
- 2:07
- Viewed 16966 times
-
Create automatic reminders
- 4:10
- Viewed 13136 times
-
Protect a document shared by password
- 1:41
- Viewed 12057 times
-
Morph transition
- 0:43
- Viewed 11231 times
-
Add a sound effect to a transition
- 3:45
- Viewed 10732 times
-
Block the transfer of a Teams meeting
- 02:40
- Viewed 21 times
-
Control the start of recording and transcription in Teams
- 03:03
- Viewed 22 times
-
Manage access to recordings and transcripts in Teams
- 02:59
- Viewed 19 times
-
Enable voice isolation in Teams
- 02:14
- Viewed 32 times
-
Add a collaborative page to a Teams channel
- 03:06
- Viewed 18 times
-
Manage a channel’s files with the Shared tab in Teams
- 03:34
- Viewed 30 times
-
Track conversations and organize channels in Teams
- 03:26
- Viewed 20 times
-
Create a team and set up the first channel in Teams
- 03:02
- Viewed 21 times
-
Create a newsletter in Outlook
- 02:23
- Viewed 56 times
-
Create an issue in an Outlook newsletter
- 03:27
- Viewed 60 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.