Change Zoom Box Amounts
In Excel2003, is there a way to change what magnification viewing
amounts are in the dropdown box? For example, in my dropdown box , I show 200%, 100%, 75%, 50%, and 25%, I want to have 150% listed. Can this be done? Thanks. |
Change Zoom Box Amounts
Hi
Don't know if the settings can be changed but you can type in any size from 10% to 400% HTH John "snax500" wrote in message ... In Excel2003, is there a way to change what magnification viewing amounts are in the dropdown box? For example, in my dropdown box , I show 200%, 100%, 75%, 50%, and 25%, I want to have 150% listed. Can this be done? Thanks. |
Change Zoom Box Amounts
I meant as a default that will always be there.
On Dec 3, 10:49*am, "John" wrote: Hi Don't know if the settings can be changed but you can type in any size from 10% to 400% HTH John"snax500" wrote in message ... In Excel2003, is there a way to change what magnification viewing amounts are in the dropdown box? For example, in my dropdown box , I show 200%, 100%, 75%, 50%, and 25%, I want to have 150% listed. Can this be done? Thanks.- Hide quoted text - - Show quoted text - |
Change Zoom Box Amounts
No way that I can see, that's a fixed part of the GUI.
However, a couple of options: a) write (or record) a macro and assign it to a shortcut key or toolbar button b) did you know you can zoom in and out by holding Ctrl and using the scroll wheel of the mouse? This goes in 15% increments, so from 100 you could get to 145 or 160 very easily, but not 150. Might be good enough though c) another approximation, but the "fit to selection" can be quite useful. Either select the right bunch of cells across the top, or even better if you have a title merged across cells which goes the right width, select this, zoom fit to selection, now you are zoomed into the same amount. This is more useful if the width is right to show all your data of course, sometimes it is very useful, other times no good at all. Obviously you can adjust the widths of your columns so that the zoom effect suits you. Hope this helps Adam snax500 wrote: In Excel2003, is there a way to change what magnification viewing amounts are in the dropdown box? For example, in my dropdown box , I show 200%, 100%, 75%, 50%, and 25%, I want to have 150% listed. Can this be done? Thanks. |
All times are GMT +1. The time now is 12:12 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com