Footer font resize when "fit to page"
 

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!

Footer font resize when "fit to page"
 

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
"Sherry" wrote in message
...
|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!