Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 - |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
change zoom based on column width | Excel Discussion (Misc queries) | |||
Please help! Print Preview Zoom is Grayed Out...Doesn't zoom. | Excel Discussion (Misc queries) | |||
Change View,Zoom as shortcut key? | Excel Discussion (Misc queries) | |||
How do I keep text viewing correctly as I change zoom % | Excel Discussion (Misc queries) | |||
How can I change decimal amounts to end with .95 | Excel Worksheet Functions |