• 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

G

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
 
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.
 
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
 
Tried it and it works just fine. You just have to make sure you add it to the front.

Thanks for your help.


GJ
 
You must log in or register to reply here.
Back
Top