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

Copper Contributor

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.

1 Reply

@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!!!