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

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.