MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Fixed Headers

Posted by Kris Lyon on July 25, 2001 7:53 AM

Is there a way to fix the header font and size across worksheets when using fit to one page. We have workbooks with 10-20 sheets with varying print areas, but we want to have the same header look and feel on all pages when printed. Even when using the same fonts in the header, the results when printed are different sizes due to the sizes of the print areas.

Any help would be appreciated.


Posted by Cory on July 25, 2001 5:41 PM

About all you can do is adjust the font sizes for each header smaller or larger on each sheet until they print the same size.
Maybe somewhere in Tools-->Options you could find a setting to change...