Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / Printing / June 2004

Tip: Looking for answers? Try searching our database.

Question about print scaling and page header/footer

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
tempest@ucla.edu - 24 Jun 2004 21:18 GMT
Does anyone know if it's possible to make Excel print headers and
footers in the original scale regardless of the print scaling of the
rest of the worksheets?

I am trying to print out some analysis worksheets and I have set every
worksheet to fit to 1 page wide by 1 page tall when printed. However,
I noticed both headers and footers are also scaled in size when
printed.  That doesn't make much sense because headers and footers are
always going to be printed outside of the header/footer margins
regardless of the how the rest of the worksheet scales.  I have page
numbers in the footer of each worksheet.  Just imagine how weird the
page numbers would look when printed in various font size from less
than 8pt to 12pt.

Any information would be appreciated.
Thanks.
Paul Cundle - 24 Jun 2004 23:04 GMT
An interesting question. I don't have an answer, other than programmatically
having the header/footer font size changed automatically before a print. So
if, for example, the page is being scaled to 70% then you would increase
your 12pt footer to 17pt to compensate.

I have a rough idea in my head how this would work and will elaborate if
necessary, but hopefully somebody will suggest something better.

Paul C,
Signature


> Does anyone know if it's possible to make Excel print headers and
> footers in the original scale regardless of the print scaling of the
[quoted text clipped - 12 lines]
> Any information would be appreciated.
> Thanks.

Rate this thread:






 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.