Microsoft Excel 2007: Set Print Area and Print Titles


These drugs are not natural male purchase levitra no prescription enhancers are known to contain nitrates. They propose an easy generic viagra australia solution to a difficult and embarrassing situation which he would not like. This is a common situation for those dealing with erectile issues. http://twomeyautoworks.com/?p=160 cheap levitra canada Smoking is truly done by burning some tobacco and inhaling the smoke and exhales the resultant. look at more info cialis sale

This article describes two features which are very useful when printing worksheets in Microsoft Excel: Set Print Area and Print Titles.

Set Print Area

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.

Set Print Area

When 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.

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: