Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 116
Default 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!
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2,718
Default 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!


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
change "true" and "false" to "availble" and "out of stock" inthestands Excel Worksheet Functions 2 July 19th 07 07:05 PM
How to resize "check box" in excel 2003? Nikhil Excel Discussion (Misc queries) 2 July 3rd 07 02:07 PM
HELP on "left","right","find","len","substitute" functions serene83 Excel Discussion (Misc queries) 5 June 27th 06 02:23 AM
Count occurences of "1"/"0" (or"TRUE"/"FALSE") in a row w. conditions in the next BCB New Users to Excel 7 May 13th 06 10:02 PM
Any IF(A2=font color=red", "1", "0") in excel? Or a way to do it? Steve Excel Discussion (Misc queries) 1 November 7th 05 02:48 PM


All times are GMT +1. The time now is 09:45 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"