Most of the work you do in Excel can be performed on your computer, but a paper or PDF copy of your files can come in handy as well. In this video, learn how to print your worksheets using a physical printer or as an electronic document.
- [Instructor] Most of the work you do in Excel can be performed on your computer. But a paper or PDF copy of your files can come in handy as well. In this movie I will show you how to print your worksheets using a physical printer or as an electronic document. My sample file is the print workbook, and you can find it in the chapter 10 folder of your exercise files collection. This workbook, it contains a single worksheet, and on it is a table. And let's say that I want to print the current worksheet.
To do that, I can press command P, and that opens the print dialog box. And you see here that I have a printer, and that it's currently set for its default settings and one copy. I can change the printer by clicking the printer control there. I can change the other settings aside from the default. I can increase or decrease the number of copies, either by typing a new number in the copies box or using the spin control to the right, and there's another option to set the printout as black and white, and you can see that that just changed in the preview.
And I'll click the checkbox again to bring it back to color. In this case, the print will only occur on one page. If I wanted to change which pages were printed, I could click all. I could do a single, or I could do a range. If I want to see more details, I can click show details, and there you see the expanded version of the print dialog box. And you can see here that I have more control over page range, I can change my paper size, also orientation.
So, for example, right now it's portrait, which means that the short edge is at top, and the long edges are on the sides. If I change to landscape orientation, then you'll notice two things happen. One is that the long edge is on top, and the short edge is on the side. And also that it went from one to two pages because everything I have here will not print on a single page. If I did want to print in this orientation, landscape orientation, and have everything fit on a single page; then I can go down to the area below the margins control and check the scale to fit box.
And there I see that I have one page wide by one page tall. And what that does is it changes the scale of the sheet. In other words, it makes the contents of the worksheet small enough for it to fit on, in this case, one page wide by one page tall. But, as you can see, you can edit the number of pages as you need. If you don't want to use the physical printer, you can use the save as PDF option, which is here at the bottom left corner. And if I click hide details, you can see that option also appears here in the bottom left corner.
You can click PDF or you can click another of the options. Those are open and preview, save as PDF, save as PostScript; and in almost every case, you'll be using PDF. So I will go ahead and click save as PDF, and I get the save as PDF dialog box. I can save it, I can choose the folder where I want to save it, give it a title, and author name, and so on. In this case, I'll just click cancel. If I want to print using my Canon printer, I can click print or to get out of the job, which I will do; I'll go ahead and click cancel.
Printing is a straightforward way to make a physical or electronic copy of your document. If you're putting together a physical report, there's nothing better than having hard copy right in front of you.
- Creating workbooks
- Manipulating cell data
- Sorting, filtering, and managing worksheets
- Using core functions and formulas
- Formatting worksheet elements
- Creating and managing conditional formats
- Working with charts
- Adding images and shapes
- Working with PivotTables
- Exporting workbooks
Skill Level Beginner
What you should know1m 11s
1. Getting Started with Excel
2. Managing Workbooks
3. Working with Worksheets, Cells, and Cell Data
4. Sorting, Filtering, and Managing Worksheets
5. Summarizing Data Using Formulas and Functions
6. Formatting Worksheet Elements
7. Working with Charts
8. Working with External Data and Objects
9. Exploring PivotTables
10. Reviewing and Sharing Spreadsheets
Further information1m 2s
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.Cancel
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.