Sometimes when you print a worksheet, you only want to print part of the data it contains. If that’s the case, you can define a print area to limit the data you print. Learn how to create and remove print areas in this video.
- [Narrator] Sometimes when you print a worksheet, you only want to print part of its contents. If that's the case, you can define a print area, to limit the data that you print. In this movie, I will show you how to create and remove print areas. And my sample file is the Print Areas Workbook. You can find it in the chapter 10 folder, of your exercise files collection. In this workbook, I have two sets of data. The first are the goals for the year 2018, and then actual sales for the years 2016 through 2018.
And let's say that I have two separate print areas here, and the first is Category Goals and Actual, which would be from A1, to B8, or actually I should probably do C8 just to include all the text in cell A. And then also, cells A10 through D15 for the second area. To define a print area, select the cells that you want to print. In this case I will include A1 through C8 by selecting them and then go to the Page Layout tab of the ribbon...
then click Print Area, and click Set Print Area. Doesn't look like anything happened, except that in the name box, we now see a print area instead of the active cell of A1. And if I click away, you can see that there is now a hairline boarder around the cells that I selected from A1 to C8. And if I go to Print Preview, by pressing Command + P, to open the Print dialogue box, you can see that I only have the element that I've selected, the area, and I do not have the rest of the worksheet.
I'll click Cancel to go back. Now let's say that I want to set a different print area. Well, to do that I can select my previous print area, click Print Area and then click Clear. Clear Print Area is the full name. And when I click away, you'll see that the hairline boarder is gone, and if I press Command + P, then the entire worksheet is included. Now click Cancel. If I want to include both of the ranges, A1 through C8, and A10 through D15, in the same print area, then I can create a multi-region print area, by selecting the first region.
In this case we'll do A1 to C8, then hold down the Command key and select cells A10 through D15. Then again on the Page Layout tab, I will click the Print Area button and click Set Print Area. And when I click away, you can see that both of those areas now have the small hairline boarder. And if I press Command + P, then I get one print area on one page and if I click the Next button, then I have a second print area on the next page.
If I want to print them on the same page, then I can click Cancel and I can go to Print Area, and Clear Print Area, and then Command + P. And all the contents of the worksheet are printed on the same page. So as you can see, there are a lot of nuances when you work with multiple print areas. A single print area will print on one sheet if it can. If you have multiple print areas, then there's a very good possibility that they will print on two or more sheets. You should always preview your work before you commit your work to paper.
- 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.