What Good Is Zooming In Excel?
(1) it helps confirm that you’ve selected everything you want to select (important with big selections where you’re using Ctrl+A or Ctrl+Shift+End). Zooming out will show you clearly whether you’ve omitted anything. In other words: it can save your @$$.
(2) it helps your eyes when you’re in the office until 11pm for the fourth straight night
(3) it helps you share your screen with someone standing behind you
(4) you tell me…
So here are some shortcuts so you can zoom faster in Excel.
Three Excel Zoom Shortcuts (Actually, Four)
Fastest: Ctrl+mouse-scroll — in other words, press the Ctrl key and (while it’s pressed) roll your mouse wheel forwards/backwards. This will zoom you in and out, and you can see exactly how far (what %) you are zoomed in/out by looking at the Zoom Slider at the bottom right of Excel (see picture below). It doesn’t get much easier than this. You get to keep your hand on the mouse. I call this a “hybrid shortcut” since you’re using both mouse and keyboard in one shortcut.
Second Fastest: Alt-W-Q (type in succession, not simultaneously) will bring up the following Zoom menu (or Alt-V-Z to use a legacy Alt sequence):
To use the menu, either (a) select a button with your mouse and click OK; or (b) type the underlined hot key (e.g., Alt-W-Q-7-<OK> will take you to a 75% zoom, since the number 7 is underlined in the 75% option). Note: you can also bring up the Zoom menu by going to View > Zoom on the Ribbon with your mouse (which is exactly what Alt-W-Q accomplishes).
If you know how Excel Alt shortcuts work, you’ll notice that once you hit Alt-W, you can also extend your sequence with either J (to go back to the default 100%) or G (to zoom to selection), instead of Q — see below:
Excel Alt shortcuts are great because Excel guides you every step of the way — you don’t have to memorize. After each key in the sequence, Excel will show you what key to press next (a “hot key”), as shown above in the red circles.
Slowest: Use your mouse to click on the slider on the bottom right of your screen (and either drag the slider left/right or click on the ‘+’ or ‘-‘). Here’s the picture of the slider again:
Recap Of Excel Zoom Shortcuts
Second Fastest: Alt-W-Q (or Alt-V-Z)
Slowest: Click on Zoom Slider
Zoom on, friends!