How to block Excel 2007 auto zooming

[Abélard]

If zoom is set to anything other than 100% in normal view and you select page break preview when you return to normal view zoom is set back to 100%. Is there a setting to maintain zoom. It looks a bit odd when the zoom went out to default settings and my pages are cut. The zoom value which I had set lets me to view my entire content across the screen.

[BillieJ]

There is no way to do that. Excel restores the page zoom on exit from page break view. This can be done via vba code only. In that alsot there is no guarantee that it will work and will provide you the actual support. But via Vba code it is possible to entirely disable the zoom option and set a default value for every sheet. You can try google to find some code that can help you for the purpose you are looking for.

[JustineBB]

Even I am too trying to find a alternative on the same. I want a default zoom option which I can keep as it is forever. But there are not settings in Excel. I tried using Macro but that messed up my entire page. I am looking for more easier solution than applying a vba code.