Fit a specific cell-area to a whole page when printing

Applys to: Excel

Difficulty: 1

Have you ever been in a situation, where you wanted to print a chart or a report from Excel out on some paper, and then spend a long time stretching and scaling the content to fit an entire A4 page? Fortunately, you can get around this very easy. In my demo-sheet, I have a 2 charts, that I want to show my boss. And I want them to fit a whole page each, including the note at the bottom: What I want to do, is click on "View" in the on the top menu, and then click on "Page Break Preview" to get this view: To start with, I only have one page break at the bottom, but since I need the two charts to be on each paper, I need another one. To add a page break, right-click on row numbers to the left, and choose "Insert page break".  Now I can drag the page break lines to fit the areas I want, like this: Now when I press the print button, I will get 2 papers with the charts fitted as on the screen. All the darkgray area, will not be printed out.  As you might have noticed, the page headline "My reports for printing" also has a darkgray background. You can resize the page breaks from either side, and since it would look bad to have the overall report headline on one of the charts, I simply dragged the top page break one row down.  This concludes this tip.