MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Excel 2019: Use the Windows Magnifier

November 21, 2019 - by Bill Jelen

Excel Use the Windows Magnifier. Photo Credit: Marten Newhall at

Someone always asks how to use Windows Magnifier on my live Power Excel seminars, so I will write up the key steps.

First, there are three versions of the magnifier. To start the magnifier, press the Windows key and + (the Plus sign on the Numeric Keypad). To stop the magnifier, press the Windows key and Esc.

The first time that you use the magnifier, it opens in a view called Full Screen. Everything on the screen becomes bigger and you can use the mouse to move around. I don't like this version. Look for the floating Magnifier toolbar. Open Views and choose Lens.

This shows the Magnifier toolbar. There are three views for Windows Magnifier:  Full Screen, Lens, or Docked. In this figure, Lens is chosen.

A magnifier lens follows your mouse cursor around the screen. You can use the Settings (gear wheel) icon in the toolbar to change the size of the lens.

With a lens, a rectangular magnifier surrounds your mouse pointer.

On some computers, the Magnifier toolbar starts out as an icon that looks like a magnifying glass. Click the icon to open the toolbar. More magnifier settings are in Windows, Settings, Ease of Access, Magnifier.

Title Photo: Marten Newhall at

Bill Jelen is the author / co-author of
Microsoft Excel 2019 Pivot Table Data Crunching

Use Excel 2019 pivot tables and pivot charts to produce powerful, dynamic reports in minutes instead of hours, to take control of your data and your business. Even if you’ve never created a pivot table before, this book will help you leverage all their remarkable flexibility and analytical power–including valuable improvements in Excel 2019 and Excel in Office 365.