• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

do not resize page footer with page size zoom

gjl

New Member
Hi all,


Let me introduce myself, my name is Gert-Jan and I work as a controller at a large asset management firm. First I have to say that I think the website is great. It has given me lots of new ideas. Thanks for that.


I've developed this new report (Excel 2003). How can I make sure that the page footer does not re size when you zoom to make the page fit.

Thanks,


GJ
 

Hui

Excel Ninja
Staff member
Gert-Jan

In Excel 2007/10, On the Page Setup Header/Footer screen there is a Scale with Document Tick box at the bottom of the page

Make sure that not ticked.

I don't have access to 2003 today to see if that option is there.
 

oldchippy

Active Member
Hi Gert-Jan,


In 2003 you can specify the size of the font (besides other things) by adding something like


&12


to your footer, see here


http://www.bettersolutions.com/excel/EZC149/VD724516331.htm
 

gjl

New Member
Tried it and it works just fine. You just have to make sure you add it to the front.

Thanks for your help.


GJ
 
Top