Excel Can Print an Entire File Even With a Mix of Worksheet Orientations

BY STANLEY ZAROWIN

Some of the worksheets in my Excel files are in landscape orientation and some are portrait. To maintain the orientations when I print the entire file, I print each worksheet separately, which is time-consuming. Is there some way to do the task in one print order?

Obviously you never tried to print the mixed-oriented file in one shot. If you had, you would have discovered that Excel anticipated your problem: It keeps track of the orientation and prints each worksheet correctly. This works in both Excel 2003 and 2007.

Don’t feel bad about the oversight: Consider the experience a gentle nudge to encourage you to further explore the abilities of your software. You may waste a few sheets of paper now and then, but it’s a small investment for what you may learn.

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.