Footer font resize when "fit to page"

S

Sherry

I want the text within the spreadsheet to shrink but not my headers/footers.
When I choose "fit to page", my footer/header fonts decrease also. Anyway
around this?

Also, I want the spreadsheet text to print as landscape but my
header/footers to print as portrait.

Any suggestions on either subject?

Thanks!
 
J

Jim Rech

If you have Excel 2007 your first wish is possible by unchecking "Scale with
document" on the Header/Footer Page Setup tab. Other than that I think
you'd have to get creative like by running the paper through the printer
twice...<g>

--
Jim
|I want the text within the spreadsheet to shrink but not my
headers/footers.
| When I choose "fit to page", my footer/header fonts decrease also. Anyway
| around this?
|
| Also, I want the spreadsheet text to print as landscape but my
| header/footers to print as portrait.
|
| Any suggestions on either subject?
|
| Thanks!
 
Top