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.