|
|
Set Print Area and Print Titles in Microsoft Excel 2007
This article describes two features which are very useful when printing worksheets in Microsoft Excel: Print Titles and Set Print Area.
Set Print Area
In addition to 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.
For example, if you have a worksheet with only five average-sized columns but several hundred rows, although the header and footer appear on every page, only page 1 will have column headings. This means that it becomes difficult to know what the figures on the other pages relate to. We can use Excel's Print Titles feature to print the column headings on every page. Print Titles are in the Page Setup section of the Page Layout tab; simply click on the button and Excel displays the Page Setup dialog box with the Sheet tab activated. In our five column worksheet example, we would only need to specify the number of rows that we would like to repeat at the top of every page. In our example, it would be only the first row. Having clicked to specify row one, we can click Print Preview to see the result and we would see that the headings are repeated at the top of each page.
Only one print area can be specified at a time. The Clear Print Area command will restore normal behaviour; so that, when you print, the entire worksheet will be printed.
When you print a worksheet, Excel will usually print 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.
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.
For example, let's say you have a worksheet with only five average-sized columns but several hundred rows, although the header and footer appear on every page, only page 1 will have column headings. This means that it becomes difficult to know what the figures on the other pages relate to. We can make use of Excel's Print Titles feature to print the column headings on every page. Print Titles are in the Page Setup section of the Page Layout tab; simply click on the button and Excel displays the Page Setup dialog box with the Sheet tab activated. In our five column worksheet example, we would only need to specify the number of rows that we want to repeat at the top of every page. In our example, it would be only the first row. Having clicked to specify row one, we can click Print Preview to see the result and we would see that the headings are repeated at the top of each page.
|
 |
Please Rate: |
|
Rating: |
 Processing ... |
(Average: Not rated) |
| Views: | 253 | |
|
| More Articles from Training | | |
| Top Articles in Training | | |
|
