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

How the election may affect taxation of business income

This report summarizes recent proposals to reform the U.S. business income tax system and considers the path to enactment of any such legislation.

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

Did you follow 2016’s biggest accounting news?

CPAs will remember 2016 as a year of new standards and new faces. How well did you follow the biggest accounting events? The 7 questions in this quiz will help you find out