28. Excel Tips - Easily change the print area
Here’s a tip on printing and how to change the print area.
Suppose you have this data, and you want to print up to Data6
Select the data you want to print:
Xl 2003 File => Print Area => Set Print Area
Xl 2007 Page Layout => Print Area => Set Print Area
You’ll notice the dotted lines around the area you want to print. They indicate the end of the page.
Now suppose you want to change the print area to include Data7
Go View => Page Break Preview
This shows Excel in page break view, and from here, you can change the print area by clicking on the edge of the highlighted area, and dragging it.
The print area is actually just a range name, so if you bring up the range name dialog box, you can change it from there too.
Excel annoyingly doesn't allow you to get rid of the small dotted lines once you have set the print area, but there are 2 ways round this:
1. Select a cell a long way away from your work area, and set that as the print area
2. Close and reopen the Excel
Training Video - Change the print area