Microsoft Excel: Printing

Name: Microsoft Excel: Printing
Author: Bob Akbar

Selective and environmentally friendly methods to output to a printer format

Preview the first lesson free — get full access to all 3 lessons.

Course: On-Demand

Hello, my name is Bob Akbar, and in these lessons you will learn printing consisting of fit to page, defining print area, landscaping versus portrait and page breaks. In this lesson, I will show you how to do fit to page. If we go under file and we go to print, we get a print preview before we can actually print this information out and we can print it to the traditional printer and we can go to the PDF option if you want to create a PDF file. Everything that we're going to discuss in this example will work the same way for either way so a physical printer or a PDF printer. Now if you notice we have everything in our page fitting beautifully. However, that is not the default setting. The default setting brings you in a normal margins and no scaling. We can do fit sheet on one page, which gives us this. We can also do fit all columns or our rows depending on what your preference is or you can customize your printing options. And when you do that you can see that you can adjust the different things. You can also choose to have your presentation fit into more than one page by one page. In our case, our second page is going to have the legend for the graph, which is not what we want. Ideally, we want ours to fit everything on one page so we're going to go back to custom scaling and we're gonna click fit on one page. And if you notice, our legends came back in and they fit. Now you may notice there's a lot of empty space that we have at the bottom here and everything is kind of small printed on top. We can change that by playing with the page orientation and we can go to landscape, and look at that. We're filling up more of the page, and we're also able to see our data represented better. Now, why would we use fit to one page or fit to two pages depending on what our preference is? One of the most important things, of course is how our presentation prints and that we show the information in the minimum number of pages that we can print this out. This is environmentally friendly and highly recommend it. Thanks for watching. Stay tuned for the next lesson where I will show you how to define print areas.

Intermediate Provider : Bob Akbar 3 Lessons · 13m in Arabic, German, English, Spanish, French, Portuguese, Chinese

Course Description

In the age of environmental responsibility, it is no longer acceptable to print many wasted pages that are not needed. This issue is easily resolved by understanding different options available to the user for different needs in data output via print. Even simple issues such as how the print is oriented makes a difference in the number of pages of paper and the amount of printing supplies that will be used in the production process. These range from simple options to having everything printed on one page for small documents and data sets to more complex.

The more complex options include defining what to print. This can be done by selecting specific areas of results data, core data, tables, ranges of data, and so forth. By using these methods, the user can print specific data that is required. Further, by using the methods discussed in this section, your actual print output will be properly formatted by you. Therefore, it will meet your expectations once the print copy is generated.

What You'll Learn

Apply the Fit to Page option to print small documents and data sets on one page
Define a print area by selecting specific results data, core data, tables, or ranges to print only what is required
Choose between portrait and landscape orientation to control the number of pages and printing supplies used
Use page breaks to define and organize how your data is laid out
Format print output so the generated copy meets your expectations
Conserve paper and print in an environmentally responsible way

Key Takeaways

Understanding the print options available in Excel lets you output only the data you need and avoid printing wasted pages.
Print orientation, such as portrait versus landscape, affects how many pages and how much printing supply are used.
The Fit to Page option allows small documents and data sets to be printed on a single page.
Defining a print area lets you print specific areas such as results data, core data, tables, or ranges of data.
Applying these methods lets you properly format your print output so it meets your expectations once the copy is generated.

Frequently Asked Questions

What does this Excel Printing course cover?

It covers Excel print options including Fit to Page, defining a print area by selecting specific areas, tables, or ranges of data, choosing landscape versus portrait orientation, and using page breaks to organize your data.

What will I be able to do after taking this course?

You will understand Fit to Page and Select Print Area, identify how to conserve paper and be environmentally responsible, recognize portrait versus landscape orientation, and describe page breaks and define your data organization.

Which lessons are included in this course?

The course includes three lessons: Fit to Page, Defining Print Area, and Landscape Versus Portrait.

How does this course help with environmental responsibility?

It teaches options that avoid printing many wasted pages, such as fitting small documents on one page, defining specific data to print, and choosing an orientation that reduces the number of pages and amount of printing supplies used.

What skills does this course build?

The course builds skills in Microsoft Excel, Data Manipulation, Data Presentation, Print Production, and variable data print output.