This article describes two features which are very useful when printing worksheets in Microsoft Excel: Set Print Area and Print Titles.
Print Titles
As well as printing headers and footers on every page, Excel also allows you to specify Print Titles. Whereas headers and footers give an overall description of the report, print titles are taken from the worksheet itself. They are normally row and column headings and they are very often an essential part of the printed report.
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
As well as printing headers and footers on every page, Excel also allows you to specify Print Titles. Whereas headers and footers give an overall description of the report, print titles are taken from the worksheet itself. They are normally row and column headings and they are very often an essential part of the printed report.
Only one print area can be specified at a time. The Clear Print Area command restores normal behaviour; so that, when you print, the entire worksheet will be printed.
Print Titles
As well as printing headers and footers on every page, Excel also allows you to specify Print Titles. Whereas headers and footers give an overall description of the report, print titles are taken from the worksheet itself. They are normally row and column headings and they are very often an essential part of the printed report.
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
As well as printing headers and footers on every page, Excel also allows you to specify Print Titles. Whereas headers and footers give an overall description of the report, print titles are taken from the worksheet itself. They are normally row and column headings and they are very often an essential part of the printed report.
Only one print area can be specified at a time. The Clear Print Area command restores normal behaviour; so that, when you print, the entire worksheet will be printed.
About the Author:
The writer of this article is a developer and trainer with Macresource Computer Training, a UK IT training company offering Microsoft Excel 2007 training courses in Birmingham, Cambridge and throughout the UK.
No comments:
Post a Comment