Forum Discussion

urvashim26's avatar
urvashim26
Copper Contributor
Apr 28, 2024

Shortcut to zoom in at 90% in microsoft excel for all workbooks without using VBA

Is there any way to zoom at specifically 90% or any other % with using keyboard shortcut keys and not using VBA?
For now, I have kept zoom in my quick access toolbar and manually add 90% at the custom field.

excel
User Adoption
  • JKPieterse's avatar
    JKPieterse
    Silver Contributor
    Apr 29, 2024

    urvashim26 Not a single short-cut, but maybe it helps?

     

    1. Press and hold Control+PageUp until the first tab is activated
    2. Press and hold Control+Shift+PageDown until the last tab is activated (all sheet tabs are selected!)
    3. Now set the zoom to 90%
    4. Press control+PageDown to ungroup the sheet selection

    You can access the zoom "-" button by pressing the F6 function key twice. Then pressing Enter once takes it from 100% to 90%.

     

    DO NOT FORGET STEP 4!!!