Excel.Tips.Net: Dynamic Headers and Footers

By Allen Wyatt for Excel.Tips.Net

If you have a large worksheet, you may want to print it out in “parts” and automatically vary the information contained in the header or footer of each part. There is no intrinsic way to do this in Excel; the best approach is a macro to do the following:



1. Set the print area based on a named range.

2. Set the header or footer based on another named range.

3. Print the print area.

4. Repeat steps 1 through 3 for each desired print area.

Notice that these steps require the use of named ranges.

Article Continued Here

This post is excerpted with permission from Excel.Tips.Net

Subscribe to the Free ExcelTips Newsletter with the links below

(for those using Excel 97 through 2003)

(for those using Excel 2007 through 2010)

241 total views, 4 views today

(Visited 140 times, 1 visits today)

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.