View Wide Documents Without Scrolling Sideways

BY STANLEY ZAROWIN

Q. I’m sure there’s a simple solution to this problem, but it’s eluded me. I often prepare wide documents—spreadsheets that I print in landscape mode. But while I’m working on them I have to scroll back and forth to see the whole document. It’s very time-consuming and annoying. Is there a way I can see the entire width without scrolling?

A. Yes. The answer is to use Zoom , a function in both Word and Excel. Despite its name, Zoom lets you enlarge or shrink the text, the page width, the whole page or multiple pages. Click on View, Zoom to call up this screen:

If you want to be able to move your cursor to easily extend from one side of the screen to the other, be sure the Page width button is selected. Determine the optimum percentage of shrinkage and then click on OK . If you may want to enlarge a section of the worksheet for easy viewing, raise the percentage above 100%.

SPONSORED REPORT

Keeping client information safe in an age of scams and security threats

A look at the Dirty Dozen tax scams and ways to protect taxpayer information.

TECHNOLOGY Q&A

How to create maps in Excel 2016

Microsoft Excel 2016 has two new mapping capabilities. J. Carlton Collins, CPA, demonstrates how to make masterful 2D and 3D maps in Excel 2016.

QUIZ

News quiz: IRS enforcement, a hot job, and audit value

The IRS’s 2016 Data Book, a “hot job” of particular interest at this time of year, and insight into how executive and audit committees view the insights from financial statement audits received attention recently. See how much you know with this short quiz.