Magnifier in Excel
July 12, 2018 - by Bill Jelen
When I am doing a presentation at a Staff Meeting or my Live Power Excel Seminar, I have started to use the Windows Magnifier to show details in the Ribbon or dialog boxes.
Excel has a great Zoom slider. You can zoom in from 100% to 400%. (You can also zoom out to 10%, letting you see A1:KZ388 on a 1080P Monitor, but that is a story for another day.) I frequently use Ctrl + MouseScrollWheelAway to zoom in. Then I use Ctrl + MouseScrollWheelTowardsMe to zoom out. This is great for values in cells. They become HUGE and readable. But it does not help at all with the Ribbon commands, with Power Query, or with choices inside dialog boxes.
When I want to show something in a dialog box, I hold the (Windows) key and press the + sign. (Note you can use either the + sign on the number keypad or the + above the equals sign, but you will have to do Ctrl + Shift + Equals to use the one not on the number keypad. To dismiss the magnifier, press + Esc.