Flaw in Excel with regard to header/footer relative scale

[AllPurpose]

I have found some other posts on this board regarding this issue but was wondering if there were any new developments. I'm using Excel 2003.

The problem occurs within Page Setup >> Page.

When you "Fit to x page(s) wide by y pages tall" excel will automatically scale down your spreadsheet to fit to a nice size. HOWEVER, the problem occurs when the header/footer font size is scaled down as well. Of course, there should be an option available to "Not scale header/footer" that would allow for, what I consider, the obviously desired _consistent_ header/footer font sizes.

Has anyone come up with a fix for this? Is the excel team working on solving this issue?

Am I missing something???

Thanks,
AP

 

[Joe Was]

For the sheets that you need the Header/Footer larger than the general proportion: Do a test print and the increase the font size for the Hearde/Footer untill you get close to what you want.

I don't think MS looks at this as a problem, so I don't think they will do anything about it. I guess they could add a CheckBox to: "Preserve actual Header/Footer Font Size when Re-Sizing Sheet." as a solution, but I do not think this will happen.

 

[AllPurpose]

The "fit to x pages..." function is incredibly useful -- it just seems that this option should be included. It really makes your spreadsheets look bad when your page numbers/headers are different sizes.