Using Set Print Area and Print Titles in Excel 2007
This article describes two features which are very useful when printing worksheets in Microsoft Excel: Set Print Area and Print Titles.
Print Titles
Each time you print a worksheet, Excel normally prints all the data that it contains. However, there are times when you only want to print a selection of your data. Although you can achieve this by hiding rows and columns, Excel offers a simpler solution.
The Page Layout tab of the Excel ribbon, is where you will find the Set Print Area drop-down menu. When you click on it, it offers two options: Set Print Area and Clear Print Area. The Set Print Area command allows you to highlight a range of data and specify that this is the only part of the worksheet that will be printed whenever you use the print command. Having chosen the Set Print Area command, Excel displays a dotted lined border around the area that has been set, in much the same way as it normally displays the page boundaries after the print command has been used.
Set Print Area
Print Titles
In the Page Layout tab of the Excel ribbon, you will find the Set Print Area drop-down menu. When you click on it, it offers two options: Set Print Area and Clear Print Area. The Set Print Area command allows you to highlight a range of data and specify that this is the only part of the worksheet that will be printed whenever you use the print command. Having chosen the Set Print Area command, Excel displays a dotted lined border around the area that has been set, in much the same way as it normally displays the page boundaries after the print command has been used.
Only one print area can be specified at a time. The Clear Print Area command can be used to restore normal behaviour; so that, when you print, the entire worksheet will be printed.