I Hope to See You Zoom

BY J. CARLTON COLLINS

Q: I use Excel on a 15-inch monitor, and I sometimes find it difficult to read the smaller font data in my worksheet. Is there an easier solution to this problem than buying a bigger monitor?

 

A: In Excel 2003, 2007 and 2010, you can zoom in and out instantly by holding down the Ctrl key while rolling the wheel on your scrolling mouse. This approach is faster and allows you to zoom up to a 400% view, down to a 10% view— and any option in between. This works in Microsoft Word, too. Microsoft Office 2007 and 2010 both include a sliding Zoom tool at the bottom right-hand corner of the screen that accomplishes the same result.

 

J. Carlton Collins (carlton@asaresearch.com) is a technology and accounting systems consultant and a JofA contributing editor.

 

Note: Instructions for Microsoft Office in “Technology Q&A” refer to the 2007 and 2010 versions, unless otherwise specified.

 

More from the JofA:

 

 Find us on Facebook      Follow us on Twitter

 

RESOURCES

Keeping you informed and prepared amid the coronavirus outbreak

We’re gathering the latest news stories along with relevant columns, tips, podcasts, and videos on this page, along with curated items from our archives to help with uncertainty and disruption.

VIDEO

Excel walk-through: Sparklines

Want to liven up your spreadsheets with some color and graphical elements? Kelly L. Williams, CPA, Ph.D., shows how to use Excel sparklines, which illustrate data trends and patterns via small charts that fit in a single Excel cell.