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

Revenue recognition: A complex effort

Implementing the new standard requires careful judgment. Learn how to make significant accounting judgments and document them and collaborate with peers for consistent application.

VIDEO

How to Excel pivot a general ledger

The general ledger is a vast historical data archive of your company's financial activities, including revenue, expenses, adjustments, and account balances. J. Carlton Collins, CPA, shows how to prepare data for, and mine data with, PivotTables.

QUIZ

News quiz: Taking an economic snapshot and looking to the future

Recent news included IRS actions that affect individuals and partnerships and a possibly influential move by a Big Four accounting firm.Take this short quiz to see how much you know about the news.