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

 

SPONSORED REPORT

Why cybercriminals are targeting CPAs

This free report expands on the most commonly found scams, why education and specialized IT knowledge help to lessen security vulnerabilities, and why every firm should plan carefully for how it would respond to a breach.

PODCAST

How tax reform — and Excel — are changing the CPA Exam

Mike Decker, the vice president of examinations at the AICPA, discusses changes being made to the exam as a result of tax reform — and about how Excel will now be available for use on the test.