Increase Screen Size in Excel

I hate to watch people squint at the screen when they use Excel. It’s no secret that we’re all getting older, and that generally speaking, our eyesight isn’t getting any better. Even with a reasonable screen resolution, Excel’s default font and cell sizes can seem tiny. While it may be tempting to start changing font sizes throughout a spreadsheet, there’s a better solution for working with Excel comfortably – using the program’s Zoom feature.

You’ve probably already played with the magnification settings on Excel’s standard toolbar, for example changing the “zoom” size to 200%. What most people don’t realize, however, is that there’s an even easier way to change the zoom in Excel, as long as you have a mouse with a scroll wheel.

To zoom an Excel worksheet to a higher magnification, simply press and hold down one the Ctrl key in the lower right of your keyboard. With the Ctrl key depressed, scroll the wheel on your mouse up to enlarge content, or down to make things smaller. Better news still? This trick also works with web pages – try it right now to increase or decrease the size of text on this page.

Author: Dan DiNicolo

Dan DiNicolo is a freelance author, consultant, trainer, and the managing editor of He is the author of the CCNA Study Guide found on this site, as well as many books including the PC Magazine titles Windows XP Security Solutions and Windows Vista Security Solutions. Click here to contact Dan.